Retreival Loop... won't stop retreiving!

[iSlak]

PHP Code:

    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?

[Alekz]

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

Alex

[iSlak]

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

I found a better loop...

PHP Code:

    $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>";


    }