mysql_fetch_row

[TheGoldenShogun]

How do you go to the next row for the mysql_fetch_row command? I have tables that have more than just one row of information but I want to get them element by element (like $result[1]." ".$result[2]) and then go to the next row. mysql_result for the query lets you specify which row with the second argument to that function but I haven't been able to find how to increment this sucker.

[chrisjk]

i'd use mysql_fetch_array instead. Use in a while loop, like this

while ($row = mysql_fetch_array($resultfromquery)) {
    print "$row["NameOfField"]<br>";
} 

That would output each row