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

Posted on 16th Feb 2014 07:03 pm by admin

This may be simple I just may need another pair of eyes..

When i get records back the below code works just fine, when I get 0 rows back it shows the warning below. As you can see I tried to code for it and you can see that the code works as it echo's my message but I want the warning to go away

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in show_coupon_list.php on line 224
No Coupons for this Catogory or Business. Please let us know about the Category that displayed no results so we can contact businesses for you!

Code: $cat_coupons = mysql_query("SELECT a.business_name, a.seq_id, a.state, a.city
FROM users a where a.seq_id = '$cat_coupons_seq_id'");

Code: $cat_num=mysql_num_rows($cat_coupons);
if ($cat_num > 0)
{
while ($row = mysql_fetch_array($cat_coupons))
{
$business_name = $row["business_name"];
$business_id = $row["seq_id"];
$state = $row["state"];
$city = $row["city"];
echo"<tr>
<td align = 'left'>&nbsp;&nbsp;<a href=show_coupon.php?business=".urlencode($business_name).">$business_name &nbsp;&nbsp;&nbsp; $city,$state </a></td>
</tr>";
}
}
else
echo"<tr>
<td>No Coupons for this Catogory or Business. Please let us know about the Category that
displayed no results so we can contact businesses for you!
</td>
</tr>";

Your Answer:

Login to answer

Other forums

Using insert variable
need a way to inert variable data to mysql database

$acc = "212121212";
$nok =

Problem writing URL into database
How would I write this into the database?

<?php echo "http://".$_SERVER['SER

Form File Upload
I've read through tons of resources and tutorials and as far as I can tell, my code is accurate, but

help with this code please?
Hello,

I am trying to build a remote upload script for my image hosting site.

I am usi

values in array being escaped
I would like to submit some values - back to the same form for checking before processing...

Which practice of iteration through containers is preferred
In the "real world" what kind of loop do most people use to iterate through a container like a vecto

Upload file and add HTML
Hey everyone,

I have a client has meeting agendas and minutes that should be posted online. I

moving mouse to display image coordinates
I have an existing MFC application that shows an image in the main window.
I'd like to be able to

the problem with str_replace
$str="hahahahahahahahahahahahahaha";
$nn=1;
$str=str_replace('ha','MyGod',$str,$nn);

form submit at godaddy?
Trying to test form submission at GoDaddy and it does not seem to work. Here's the page...

h