[RESOLVED] MYSQL Num Rows Problem - Help Needed

[modpluz]

why do i get an error when i run this code?

$sql = "SELECT * FROM tbl_Quotes";
$rs = mysql_query($sql);
$numrows = mysql_num_rows($rs); 

the error is below
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource

thanks

[modpluz]

anyone please???

[penagate]

Please don't bump your posts after such a short time.

You can dump the last error message generated by MySQL by using the mysql_error() function.

$sql = "SELECT * FROM tbl_Quotes"; 
$rs = mysql_query($sql);
if (mysql_errno()) {
  echo mysql_error();
} 

[uttam]

why do i get an error when i run this code?

$sql = "SELECT * FROM tbl_Quotes";
$rs = mysql_query($sql);
$numrows = mysql_num_rows($rs); 

the error is below
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource

thanks

use this one.

$sql = "SELECT * FROM tbl_Quotes";
$rs = mysql_query($sql) or die(mysql_error());
$numrows = mysql_num_rows($rs); 

[john tindell]

Please don't bump your posts after such a short time.

Got there before me

uttam die should be only for debugging, as it will stop the execute of the script, for live scripts use penagates method of displaying MySQL errors.

[the182guy]

it errors because that function does not exist it is:

mysql_numrows() not mysql_num_rows

so...

$row_count = mysql_numrows($result);

[lintz]

the182guy, I use mysql_num_rows all the time to find out how many records have been returned from my query without it ever displaying an error.

[penagate]

When in doubt, refer to the manual!

Note: For downward compatibility, the following deprecated alias may be used: mysql_numrows()

[lintz]

who ever reads a manual these days!!

[john tindell]

the182guy, I use mysql_num_rows all the time to find out how many records have been returned from my query without it ever displaying an error.

If this would try the error message he would have seen first would be, Fatal error: Call to undefined function.

It's not working because their is a problem with his query. This is not returning a valid resource that mysql_num_rows requires. Check with msql_error is your best bet.

who ever reads a manual these days!!

Like my lecturer keeps telling us RTFM

[lintz]

LMAO