Posted by "Matt Stone" on 12/18/05 11:19

There's a big difference between the first and second scripts your using.
The second one isn't using a while loop so will only return the first row in
the recordset. See below.

HTH

Cheers
Matt

----- Original Message -----
From: "Anasta" <neretlis@westnet.com.au>
To: <php-general@lists.php.net>
Sent: Sunday, December 18, 2005 8:21 AM
Subject: [PHP] Need help with modifying values



> while ($myrow = mysql_fetch_array($result)) {
>
> echo "<tr><td>" . $myrow['Name'] . "</td>";
> echo "<td>" . $myrow['Rating'] . "</td>";
> echo "<td bgcolor='cyan'> <a href='modify_values2.php?id=" . $myrow['ID']
..
> "'>Modify</a></td></tr>";
> }
> ?>
+++++++++++++++++++++++++++++
>
>
> $myrow = mysql_fetch_array($result);
>
> $Name = $myrow['Name'];
> $Rating = $myrow['Rating'];
>
> ?>

[Back to original message]