foreach and mysql_fetch_array problem

Hi all, I am trying to build up a table using values from a db as follows... mysql_select_db($db, $sql_connection); $result = mysql_query("SELECT * FROM $table WHERE $query LIMIT $limit",$sql_connection); $output = "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"370\">\n"; foreach(mysql_fetch_array($result) as $key => $article){ //stuff } now if I use a while loop ie: while ($array = mysql_fetch_array($result)){ //stuff } all the matched rows are processed, however with the foreach model, $article isnt an array, it is the first row all merged together. Any ideas? ;o)