What is wrong with this query script?

admin

Administrator
Staff member
What is wrong with this? All I want is the three fields info to be displayed in table format, but all it does is display the nick_names in all three coloumns in a continuos loop.


$sqlmembers = mysql_query ("SELECT nick_name,email, url FROM members ORDER by id asc");


while(mysql_fetch_row($sqlmembers)){
$nick_name=mysql_result($sqlmembers);
$email=mysql_result($sqlmembers);
$url=mysql_result($sqlmembers);
echo "<table border='1'cellpadding='1' cellspacing='1' width='100%'>";
echo "<tr>";
echo "<td width='50%'>$nick_name</td><td width='25%'>$email</td><td width='25%'>$url</td>";
echo "</tr>";

}


Donald
 
Back
Top