Printing from DB

[Danni]

Im trying to call from the "draw" table and order the data by row.

number - email - username
number - email - username

and so on.

However it is not printing for me. 🙁

<?

# setup SQL statement
$sql  = " SELECT * FROM draw WHERE number = '$number'";

# execute SQL statement
$rs = mysql_query($sql, $cid);
if (mysql_error()) { print "Database Error: $sql " . mysql_error(); }

# display results
print "<p><table cellpadding=4>\n";
while ($row = mysql_fetch_array()) 

$number = $row["$number"];
$username = $row["username"];
$email = $row["email"];

    print "<tr>";
	print "<td>$number</td>\n";
	print "</td>";
    print "<tr>";
	print "<td>$email</td>\n";
	print "</td>";
	print "<tr>";
	print "<td>$username</td>\n";
	print "</td>";

    print"</table>";
?>

Ok, now what did I forget to do? 🙁

[Drakla]

well in your code I think you mean to have braces around all the print statements after while ($row = mysql_fetch_array()) up until before the close table tag, because currently it's just shoving a number into the $number a load of times, and then printing out one row.

use the php tags instead of the code tags, too for luvvly coloured nonsense.

Oh - just looked at the html, too - you're not closing your <tr> tags, you're doings a 2nd </td> instead - that could be causing a right mess.