mysql_fetch_array() is misbehaving - Please help

[s3nzo]

Hey guys i'm using this code

if(!$row = mysql_fetch_array($catQuery, MYSQL_BOTH))
  $images->showError();
else while($row)
  print $row['category'].'<br>'; 

and my script is showing only one DB entry and repeat it forever.

[i0nutzxp]

maybe this ....

$i = 0;
while($row = mysql_fetch_object($catQuery))
{ 
     print $row->category.'<br>'; 
     $i++;
}
if  ( ! $i)  $images->showError(); 

[s3nzo]

Thanks bro, The solution was

while($row = mysql_fetch_array($catQuery, MYSQL_BOTH)) 

Even though i still don't understand it but yeah it solved my problem

[i0nutzxp]

while(resource) => while the resource exists (infinite loop when you dont delete from resource)
while($row = resource) => while the resource is copied to variabile $row
while($row == resource) => while resource is equal with row

PS: use MYSQL_ASSOC OR MYSQL_NUM instead MYSQL_BOTH