Re: foreach and mysql_fetch_array problem

Try: Bix wrote:

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"; while($row=mysql_fetch_array($result)) {

foreach($row 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)