problems with mySQL

[wiseass]

got problems with mySQL:

$output = mysql_query("SELECT name FROM db_users");
$num = mysql_num_rows($output);

returns...

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in c:\inetpub\wwwroot\mysql.php on line 15

help pls...

[mrskhris]

Try using mysql_error() for checking the status of the query. Basically that error means your query has failed... possible reasons - no connection to DB, wrong syntax of query, wrong table/field name, etc,etc,etc...