Re: mysql_fetch_array()

On Thu, 8 Mar 2001 14:03, Deependra B. Tandukar wrote: > Greetings! > > I am using PHP and MySQL in RedHat 6.0. > I have used mysql_fetch_array() to display the datas in web page but > all the columns are printed twice. What can be the wrong with my code: > <?php > $connection=mysql_connection(...............); > $db=mysql_select_db(.....................); > $sql="select * from my db"; > $sql_result=$mysql_query($sql,$connection); > print "<table>"; > while ($row=mysql_fetch_array($sql_result)) > { > print "<tr>"; > foreach ($row as $field) > print "<td>$field</td>"; > print "<td><a href=\"search.php?ID=$row[ID]\">"; > print "Get it"; > print "</a></td>"; > print "</tr>"; > } > print "</table>"; > ?> > > But it works fine with mysql_fetch_row() however it does not pass the > pass the variable ID. > > Looking forward to hearing from you. > > Warm regards, First up, shouldn't you have {} to delineate what is actually the foreach procedure(s)? I would suggest using extract within your While loop to make the table fields available as variables. while ($row=mysql_fetch_array($sql_result)) { extract($row); echo "<tr>"; echo "<td>$field</td>"; \\ or whatever the field is called echo "<td><a href=\"search.php?ID=$ID\">"; echo "Get it"; echo "</a></td>"; echo "</tr>"; } -- David Robley | WEBMASTER & Mail List Admin RESEARCH CENTRE FOR INJURY STUDIES | http://www.nisu.flinders.edu.au/ AusEinet | http://auseinet.flinders.edu.au/ Flinders University, ADELAIDE, SOUTH AUSTRALIA