mysql_fetch_rows shows invalid mysql resource

Question

i am fetching data from a table using

mysql_fetch_aaray

the data is displaying correctly now i want that if data is not exist it will print no data found

i tried with the following code

ghgf

am getting error in mysql_num_rows it shows

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

possible duplicate of Warning: mysql_fetch_* expects parameter 1 to be resource, boolean given error — John Conde
– John Conde, Commented Jul 31, 2012 at 2:11

Poonam · Accepted Answer · 2012-02-10 07:20:30Z

2

From your question I found that in if condition you have not passed resource name properly

mysql_num_rows($result33) instead of `mysql_num_rows($result)`

This will seems to solve your warning(error)

answered Feb 10, 2012 at 7:20

Poonam

4,6411 gold badge17 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Poonam Over a year ago

there is a chance that your query is not proper,echo your query and fire it in phpmyadmin,just check it works or not

Bjoern · Accepted Answer · 2012-02-10 07:41:07Z

1

Your SQL statement is probably throwing an error which you don't catch.

There might be something wrong with the SQL statement, or the tables don't have the same amout of fields - but those are just two shots in the dark.

To debug this further, try

$sql33="your sql here";
$result33=mysql_query($sql33);

if (!$result) {
    die('Invalid query: ' . mysql_error());
}

Another one, you're referencing a wrong resource in your if-condition:

Change

if (mysql_num_r($result<=0))

to

if (mysql_num_rows($result33<=0))

edited Feb 10, 2012 at 7:41

answered Feb 10, 2012 at 7:24

Bjoern

16.3k4 gold badges47 silver badges50 bronze badges

2 Comments

Wiseguy Over a year ago

Still a few problems with if (mysql_num_r($result33<=0)), such as missing "ows" in the function name and passing the Boolean expression $result33 <= 0 to that function.

Bjoern Over a year ago

mysql_num_r is not known to me. Change mysql_num_r to mysql_num_rows.

Giannis · Accepted Answer · 2012-02-10 07:29:00Z

0

Try this one:

    list($count) = mysql_fetch_row($result33);
if ($count<=0)
{
echo "No Data Found";

}

instead of:

    if (mysql_num_r($result<=0))
{
echo "No Data Found";

}

answered Feb 10, 2012 at 7:29

Giannis

8137 silver badges13 bronze badges

Comments

Timur · Accepted Answer · 2012-02-10 08:00:24Z

0

Function with name mysql_num_r does num exists. Use mysql_num_rows instead. But this is may be a typo.
You are passing result of boolean expression $result<=0 to mysql_num_rows, not a resource. Place brackets correctly:

if( mysql_num_rows($result)<=0 )

answered Feb 10, 2012 at 8:00

Timur

6,7381 gold badge30 silver badges37 bronze badges

Collectives™ on Stack Overflow

mysql_fetch_rows shows invalid mysql resource

4 Answers 4

1 Comment

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related