my sql lookup help

[marklarah]

<?php



$check = "SELECT * FROM users WHERE active = '1'";
mysql_query($check) or die('Error, query failed now');
$us = mysql_num_rows($check);







echo '<table border="0">';

while ($us = mysql_fetch_assoc($check)){
echo '<tr><td><b>';
echo $us['username'];
echo ' (';
echo $us['level'];
echo ')<b></td></tr>';
}
echo '</table>';

?>

 

 

Why wont it work????

[trq]

Change...

 

or die('Error, query failed now');

 

to....

 

or die(mysql_error());

 

Do you get an error?

[revraz]

What purpose does this line serve

 

$us = mysql_num_rows($check);

 

[marklarah]

 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home2/tlscom/public_html/side.php on line 104

 

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home2/tlscom/public_html/side.php on line 114

[marklarah]

What purpose does this line serve

 

$us = mysql_num_rows($check);

 

 

Ive changed it to mysql_fetch_array. Its for echoing the user (from the returned array)

[trq]

Post your current code.

 

ps: You might want to take a look at this thread in regard to checking your results prior to attempting to use them.