While Loop using PHP with a MySQL server

Question

I have a database (SQL) with the table "Staff" with two records in it. I am required to display the contents of these records on a web page using PHP.

<html>
<head>
<title>CES Staff details</title>
</head>

<body>

**code emitted**

<?php
$row = mysql_fetch_array($result) ; 
$looping = 1;
$i = $row.length;
while ($looping <= $i)  
    {
        echo $row["Name"].", Room ".$row["Room"].", Tel ".$row["Telephone"] ;
        $looping++;
    }
?>
</body>
</html>

How would I change the while loop correctly so that it will display both records on the page.

Thanks!

Nothing, but removing the while loop would display the first record. — Chrisosaurus
– Chrisosaurus, Commented Feb 22, 2012 at 13:43

Michael Berkowski · Accepted Answer · 2012-02-22 13:43:45Z

16

mysql_fetch_array() only retrieves a single row from the database. You need to call it inside your while loop to retrieve all rows. The $looping increment is unnecessary here, since mysql_fetch_array() returns false when no more rows are available.

while ($row = mysql_fetch_array($result))  
{
    echo $row["Name"].", Room ".$row["Room"].", Tel ".$row["Telephone"] ;
}

answered Feb 22, 2012 at 13:43

Michael Berkowski

271k47 gold badges450 silver badges395 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Nosajimiki Over a year ago

NOTE: 'mysql_fetch_array' was deprecated in PHP 5.5.0, and it was removed in PHP 7.0.0. PHP 5.x is also deprecated; so, this method should no longer be used.

napolux · Accepted Answer · 2012-02-22 13:42:56Z

2

I'll do...

while ($row = mysql_fetch_assoc($result)) {
   // print $row;
}

answered Feb 22, 2012 at 13:42

napolux

16.2k9 gold badges55 silver badges72 bronze badges

Comments

Jasper De Bruijn · Accepted Answer · 2012-02-22 13:43:51Z

1

while ($row = mysql_fetch_array($result))  
    {
        echo $row["Name"].", Room ".$row["Room"].", Tel ".$row["Telephone"] ;
    }

answered Feb 22, 2012 at 13:43

Jasper De Bruijn

1,4447 silver badges11 bronze badges

Comments

JConstantine · Accepted Answer · 2012-02-22 13:43:07Z

0

<?php
$qry = mysql_query($result); 
while ($row = mysql_fetch_array($qry))  
    {
        echo $row["Name"].", Room ".$row["Room"].", Tel ".$row["Telephone"] ;
    }
?>

answered Feb 22, 2012 at 13:43

JConstantine

3,9411 gold badge36 silver badges46 bronze badges

Comments

jasonlfunk · Accepted Answer · 2012-02-22 13:44:21Z

0

PHP has great documentation with examples. Check out the example for mysql_fetch_array().

Your code should look like this:

<?php
  while($row = mysql_fetch_array($result)) {
     echo $row["Name"].", Room ".$row["Room"].", Tel ".$row["Telephone"] ;
  }
?>

answered Feb 22, 2012 at 13:44

jasonlfunk

5,2695 gold badges32 silver badges39 bronze badges

Comments

Djumaka · Accepted Answer · 2012-02-22 13:44:58Z

0

Use this

while($row = mysql_fetch_array($result)) 
{
   echo $row["Name"].", Room ".$row["Room"].", Tel ".$row["Telephone"] ; 
}

In php there is no such thing like $row.length; the "." is an operator for string concatenation. Read more on mysql_fetch_array at http://php.net/manual/en/function.mysql-fetch-array.php.

answered Feb 22, 2012 at 13:44

Djumaka

5104 silver badges12 bronze badges

Comments

Aman · Accepted Answer · 2016-02-26 09:16:40Z

0

<?php
  while($row = mysqli_fetch_array($result,MYSQLI_ASSOC)) {
     echo $row["Name"].", Room ".$row["Room"].", Tel ".$row["Telephone"] ;
  }
?>

answered Feb 26, 2016 at 9:16

Aman

1

1 Comment

Ravi Hirani Over a year ago

mysql and mysqli both are different. You are correct if he was using mysqli instead of mysql :)

Collectives™ on Stack Overflow

While Loop using PHP with a MySQL server

7 Answers 7

1 Comment

Comments

Comments

Comments

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

1 Comment

Comments

Comments

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related