Loops

[jennifer_ann]

I have this php page that works fine. However, I need a loop in there so it reads all the lines in my table in the database. As of now it is only returning the first line of the table. Can anyone help me?

<?php
$Name=$_GET['Name'];
$Description=$_GET['Description'];
$Price=$_GET['Price'];
$type = $_GET['type'];
// open connection to database
$connect = mysql_connect("localhost", "root", "");
if (!$connect)
{
    print "unable to connect!";
    exit;
}
//select database to use
$db= mysql_select_db ("mapleside");
if (!$db)
{
        print "could not select database";
    exit;
}
// create SQL query     string
$query = "SELECT * from $type"; // Well select entries from the table selected in the form
$result = mysql_query($query) or die
    ('Error, select query failed');

$row = mysql_fetch_array($result);


$name = $row["Name"];
$Description = $row["Description"];
$Price = $row["Price"];

echo $name.'<br>';
echo $Description.'<br>';
echo $Price.'<br>';

mysql_close();
?> 

[Errant]

Add this to your code:

//get the number of rows and set a counter variable
$row_num = mysql_num_rows($result);
$no = 0;

while ($no < $row_num)
       {
   $row = mysql_fetch_array($result);


   $name = $row["Name"];
   $Description = $row["Description"];
   $Price = $row["Price"];

   echo $name.'<br>';
   echo $Description.'<br>';
   echo $Price.'<br>';   

   $no++;
   }

instead of:

$row = mysql_fetch_array($result);


$name = $row["Name"];
$Description = $row["Description"];
$Price = $row["Price"];

echo $name.'<br>';
echo $Description.'<br>';
echo $Price.'<br>'; 

The while loop keeps looping round until $no reaches the number of rows - and as the mysql_fetch_assoc() is inside the loop it is moved on to the next row of the results each time. Hence the whole thing gets echoed.

[jennifer_ann]

Could you please explain to me what the $no stands for?

[Houdini]

while($row = mysql_fetch_array($result)){
echo "Name = ".$row['Name']."<br />";
echo "Description = ".$row["Description"]."<br />";
echo "Price = ".$row["Price"]."<br />";
}

[Errant]

Houdini wrote:

while($row = mysql_fetch_array($result)){
echo "Name = ".$row['Name']."<br />";
echo "Description = ".$row["Description"]."<br />";
echo "Price = ".$row["Price"]."<br />";
}

well yes that would be simpler 😃 my way is just the way I always do it and it gets used all the time - not just for the mysql!!! 2nd nature LOL

For refernece $no is just a variable I called so that we know how many times the while loop has executed. ($no++; adds 1 to the variable at the ned of every execution).

That way when $no reaches the number of rows in the table (my variable $row_num)
the while loop stops executing. (i.e when $no is no longer less than (<) $row_num).