[PHP] foreach and mysql_fetch_array problem

[Bix]

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)



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php