Re: [PHP] foreach and mysql_fetch_array problem

[Marek Kilimajer]

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)





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