Why does it loop?

[Anon]

I use this code to echo results from mysql db

for ($i = 0; $i <= $rows; $i++) {
echo '<tr>
<td bgcolor="'.row_color($i).'"><a href="detail.php?id='.$data['id'].'">'.$data['name'].'</a></td>
<td align="center" bgcolor="'.row_color($i).'">'.$data['regno'].'</td>
<td align="center" bgcolor="'.row_color($i).'">'.$data['breedingno'].'</td>
<td align="center" bgcolor="'.row_color($i).'">'.$data['bcolor'].'</td>
<td align="center" bgcolor="'.row_color($i).'">'.$data['colorv'].'</td>
<td align="center" bgcolor="'.row_color($i).'">'.$data['gender'].'</td>
<td align="center" bgcolor="'.row_color($i).'">'.$data['type'].'</td>
<td align="center" bgcolor="'.row_color($i).'">'.$data['gaits'].'</td>
<td align="center" bgcolor="'.row_color($i).'">'.$data['price'].'</td>
<td align="center" bgcolor="'.row_color($i).'">'.$data['f'].'</td>
<td align="center" bgcolor="'.row_color($i).'">'.$data['m'].'</td>
<td align="center">&nbsp;</td>
</tr>';
}

And, I get maybe 1 or 2 numrows, but it echoes the SAME result 3 times...
for ex. I get 2 results, where name is Test and Tester, it echoes Test 3 times, and Tester 0 times...

All replys good replies 🙂

Thanks, Arni

[[deleted]]

You need to run mysql_fetch_row or mysql_fetch_array for each row you want to fetch from the database.

Check out the manual on how MySQL functions work.

[Anon]

I simple changed the for loop to this:
for ($i = 0; $i <= $rows; $i++) {
$data = db_fetch_array($result);
echo '<tr>
<td bgcolor="'.row_color($i).'"><a href="detail.php?id='.$data['id'].'">'.$data['name'].'</a></td>
<td align="center" bgcolor="'.row_color($i).'">'.$data['regno'].'</td>
<td align="center" bgcolor="'.row_color($i).'">'.$data['breedingno'].'</td>
<td align="center" bgcolor="'.row_color($i).'">'.$data['bcolor'].'</td>
<td align="center" bgcolor="'.row_color($i).'">'.$data['colorv'].'</td>
<td align="center" bgcolor="'.row_color($i).'">'.$data['gender'].'</td>
<td align="center" bgcolor="'.row_color($i).'">'.$data['type'].'</td>
<td align="center" bgcolor="'.row_color($i).'">'.$data['gaits'].'</td>
<td align="center" bgcolor="'.row_color($i).'">'.$data['price'].'</td>
<td align="center" bgcolor="'.row_color($i).'">'.$data['f'].'</td>
<td align="center" bgcolor="'.row_color($i).'">'.$data['m'].'</td>
<td align="center">&nbsp;</td>
</tr>';
}

And that results ok, thanks vincent