problem with displaying database info

[ohbigpete]

im having a problem with my code retrieving info from my database and having it displayed under a while loop. handle, status, and location are all fields in my db with a type of varchar. im pretty lost as to why its not working. if anyone has any thoughts, it would be much appreciated. here is the code

<?
// retrieve info from the database
$result = mysql_query("SELECT * FROM members ORDER BY id ASC",$link);
while ($myrow = mysql_fetch_row($result)) {
      printf("<tr bgcolor=#333345><td>%s</td><td>%s</td><td>%s</td><td align=center><a href=?bio=$myrow[1]>Bio</a></td></tr>", $myrow["handle"], $myrow["status"], $myrow["location"]);
     } ?> 

[Rayman3_tk]

Your output string is incorrect: try this:

echo("<tr bgcolor=#333345><td>%s</td><td>%s</td><td>%s</td><td align=center><a href=?bio=".$myrow[1].">Bio</a></td></tr> ".$myrow["handle"].", ".$myrow["status"].", ".$myrow["location"]."");

Still, this won't result in pretty HTML...🙂

[Rayman3_tk]

Oh, and replace mysql_fetch_row with mysql_fetch_array.

Mysql fetch row does not return a associative array, so myrow["handle"] would be empty.