Welcome to WebmasterWorld Guest from 126.96.36.199
I have no problem getting one row from the db with:
I have tried to loop, but with no success, I did however manage to grind the server to a halt as my script produced and infinite loop :-).
$result=mysql_query("SELECT * FROM sometable");
This will automatically terminate when the last row has been processed.
The difference between mysql_fetch_row() and mysql_fetch_array() is that the first returns the results in a numeric array ($row, $row etc), while the latter returns a the results an array containing both numeric and associative keys ($row["name"], $row["email"] etc). mysql_fetch_object() returns an object ($row->name, $row->email etc).