Aug 12, 2002 #1 vr76413 Programmer Feb 26, 2002 65 US When i did a SQL query i get a bunch of records....now i want to display these records , one record per row on screen in my php page... Can anyone help me .... thanks and any help is appreciated...
When i did a SQL query i get a bunch of records....now i want to display these records , one record per row on screen in my php page... Can anyone help me .... thanks and any help is appreciated...
Aug 12, 2002 #2 Bastien Programmer May 29, 2000 1,683 CA <? $result = mysql_query($sql, $conn); echo "<table>"; while $row = mysql_fetch_array($result){ $someValue = $row["someDBField"]; $anotherValue = $row{"anotherfield"]; echo "<tr><td>$someValue</td><td>$anothervalue</td>"; } echo "</table>"; ?> hth Bastien There are many ways to skin this cat, but it still tastes like chicken Upvote 0 Downvote
<? $result = mysql_query($sql, $conn); echo "<table>"; while $row = mysql_fetch_array($result){ $someValue = $row["someDBField"]; $anotherValue = $row{"anotherfield"]; echo "<tr><td>$someValue</td><td>$anothervalue</td>"; } echo "</table>"; ?> hth Bastien There are many ways to skin this cat, but it still tastes like chicken
Aug 12, 2002 #3 arlequin Programmer Sep 21, 1999 232 UY Beastien: How about: <? $result = mysql_query($sql, $conn); echo "<table>"; while $row = mysql_fetch_array($result){ $someValue = $row["someDBField"]; $anotherValue = $row{"anotherfield"]; echo "<tr><td>$someValue</td><td>$anothervalue</td></tr>"; } echo "</table>"; ?> Arlequín arlequin@montevideo.com.uy http://www.arlequinadas.com Upvote 0 Downvote
Beastien: How about: <? $result = mysql_query($sql, $conn); echo "<table>"; while $row = mysql_fetch_array($result){ $someValue = $row["someDBField"]; $anotherValue = $row{"anotherfield"]; echo "<tr><td>$someValue</td><td>$anothervalue</td></tr>"; } echo "</table>"; ?> Arlequín arlequin@montevideo.com.uy http://www.arlequinadas.com