could someone please explain / show how to retrieve query results in an array and then how to loop through them all and display all the fields ?

and which method is better ? arrays or mysql_result() ?

EDIT: (for displaying more than one row of data that is)