$result = mysql_query('SELECT * FROM foo');

while ($row = mysql_fetch_assoc($result)) {
    // Do something with row
}