MySQL with For Loop

[ollmorris]

I want to echo mysql results within a for loop.

For example I have:

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

and I want to print mysql results within that loop as if it were a while loop (i.e. for each iteration a new record from the table is selected). Can this be done?

Thanks
Oll

[paulnaj]

Hi ollmorris, the quick answer is yes.

<?php
// Assuming ...
$numrows = mysql_numrows($result);

// Then ...
for($i = 0; $i < $numrows; $i++){
	$row = mysql_fetch_array($result);
	// Do stuff with $row
}

?>

But using the while loop is the way you'd normally do it.

Paul.