mysql and for loop problem

[Anon]

Hi PHP people,

I have problem with use mysql and for loop:

$result = mysql_query("SELECT * FROM Division",$conn);

$row = mysql_num_rows($result);

for ($i=1; $i<= $row; $i++){

$myrow = mysql_fetch_row($result);
echo ($myrow["DivisionID"])."<br>";
echo ($myrow["DivisionName"])."<br>";

}

RESULT: show all even row and skip all odd row. But if I change $i=0; it shows all Odd row and Skip all Event rows.

If I use WHILE LOOP as below it shows no problem.
while ($myrow = mysql_fetch_row($result)) {

echo "<tr>";
echo "$myrow[0] </br>";
echo "$myrow[1] </br>";

}

If you know why please help.

Thanks alot.

Chuong.

[Anon]

i think this will give u the rquired solution....

<?

     $query = "SELECT * FROM Division";  
     $result = mysql_query($query,$conn); 
	 $row = mysql_num_rows($result);

	 for ($i=1; $i<=$row; $i++)
	 {
	 $myrow = mysql_fetch_row($result); 
     echo ("DivisionID : $myrow[0]");
	 echo ("DivisionName :$myrow[1]")."<br>"; 
     }
?>


                                                     regards... Kaushik

[Anon]

Thank you Kaushik,

It works! but if I want to display result base on loop counter of the for loop it still have problem.

Thanks anyway.

Chuong.