a little explanation about mysql_fetch_aray

[duuudie]

Hi
considering this code:

 
$result = @mysql_query('SELECT * FROM huh ORDER BY pk ASC LIMIT 0, 30');
while ( $row = mysql_fetch_array($result) ) { 
   echo('<p>' . $row['test'] . $row['pk'] . '</p>'); 
 }

I need a little explanation on this part:

 while ( $row = mysql_fetch_array($result) ) { 
   echo('<p>' . $row['test'] . $row['pk'] . '</p>'); 
 }

what's the concept?

thanks a lot for your time

[Gaheris]

mysql_fetch_array will return the next record from the result of your SQL query as an array with numeric and string indices. Other mysql_fetch functions are mysql_fetch_row (only numeric indices), mysql_fetch_assoc (only string indices) and mysql_fetch_object (returns an object).

[freakysid]

While there are still rows in the mysql result set, the code will fetch each row from the result set as an associative array.

$row = mysql_fetch_array($result);

grabs one row from the results set as an associative array where the field names are used for the keys.

In the echo statement the code is outputing the values of specific fields from the current row in the result set (which are held in the associative array $row).

The while loop will keep executing until there are no more rows left to fetch in the query result set.

[duuudie]

thank you so much guys

you've been a great help.

Now I'm a mysql_fetch functions professional

thumbs up.