Help with error: mysql_num_rows(): supplied argument is not a valid

JamieinNH

I am VERY new at PHP.. ok, let's say I have the Sam's Learn PHP in 24 hours and I am on hour 3..

I am trying to modify a bit of code, and I run into this error from my logs:

[11-Mar-2005 17:32:36] PHP Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /big/dom/domainname/www/testing/crmtest/modules/Products/Product.php on line 20

The line it's talking about is here:

PHP Code:

16 //Retreive the list from Database
17 $tktresult = mysql_query("select * from products where deleted =0");
18
19 //Retreiving the no of rows
20 $noofrows = mysql_num_rows($tktresult);
21
22 //Retreiving the start value from request
23 if(isset($_REQUEST['start']) && $_REQUEST['start'] != '')
24 {
25     $start = $_REQUEST['start'];
26 }
27 else
28 {
29    

30    $start = 1;

Can someone give me a hint as to what is wrong? Thanks for any help!

Jamie

thorpe

can we see the code you use to connect with?

mtmosier

What it means is that $tktresult is not valid. Which would imply that your query statement failed for whatever reason. You can change your query line like this to see the error.

$tktresult = mysql_query("select * from products where deleted =0") or die(mysql_error());