Retreival Loop... won't stop retreiving!

while ($row = mysql_fetch_row($result)) {

echo $row[2];
echo "<input name=viewid type=radio value=$row[0]>";
echo "<br>";
echo "<br>";


}


There are two records in the table I am querying. The loop displays both records, then continues to echo the second record infinitely.

Or in other words... the loop won't stop running.


Why is this?

Hi,
I had a similar problem...
Try to repair the table, it helped in my case...

Alex

I fixed the problem. I was using poor loop logic.

I found a better loop...





$numrows = mysql_num_rows($result);

for ($i =0; $i < $numrows; $i++) {

$row = mysql_fetch_row($result);
echo $row[2];
echo "<input name=viewid type=radio value=$row[0]>";
echo "<br>";
echo "<br>";


}