How to read mysql results with FOR loop

[mateo]

Hello,

Could anybody show me some properly constructed script which read MySQL result ?

I have some problems with making some equivalent for:

while ($row=mysql_fetch_array($result)) {
print($row["field1"]);
print($row["field2"]);
// and so on
}

How it could be made with FOR loop ?

Thanks

Best regards

[gushy]

Whay would you want to use a for loop? That would indicate that you know the size/number of results before performing the query?

I would use a do{}while(). ie:

$sql = "SELECT * FROM table";
$result = mysq_query($sql);
do {
echo $row[field1];
echo "<br>";
echo $row[field2];
echo "<p>";
}while($row = mysql_fetch_array($result));

If you need to limit your results, use SQL to limit it, it's much easier.

-- Nick Gushlow.

[Anon]

But if you want to use a for loop, do this:

$res=mysql_query("select * from table");
for ($c=0;$c<mysql_num_rows($res);$c++) {
$row=mysql_fetch_array($res);
}

but I usually use the while() loop myself...

[mateo]

Thanks a lot, I wanted to confirm myself about understanding FOR loop ;-)

Thanks

Best regards