Re: foreach and mysql_fetch_array problem

I need to access the row by colum name... eg: $row['id'] $row['title'] $row['detail'] My table gen script puts the relelvant fields into the right boxes, and my maths works from the $key to put <tr>s in the right place. So i need a loop that will loop as many times as there are rows, so while works fine, but i also need a key, so that is why i wanted to use foreach(mysql_fetch_array($result) as $key => $value) but my problem arises when i try and access $value in the foreach loop, it is not an array of the row, but all the values in the row imploded together. "Marek Kilimajer" <kilimajer@webglobe.sk> wrote in message news:3EDC6E99.7010206@webglobe.sk... > 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) > > > > > > >