Jump to content

Hideing a mysql result error


skatermike21988

Recommended Posts

Hello,

i am trying to find a way to hide this error
[code]

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in *****/index.php on line 75
[/code]
What i am doing is making a search form, the search works fine but when there are no results it comes up with error and displays this text i have it set to say underneath it:
[code]
Your Search Has Returned No Results
[/code]
so when nothing returns this is what i am getting
[code]

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in ***/index.php on line 75

Your Search Has Returned No Results
[/code]
All i want to display is the your search has returned no results
Link to comment
https://forums.phpfreaks.com/topic/20697-hideing-a-mysql-result-error/
Share on other sites

You should use [url=http://www.php.net/mysql_num_rows]mysql_num_rows()[/url] to find out if any rows were returned.

[code]
if (mysql_num_rows($result))
{
    mysql_fetch_array(...)
}
else
{
    print 'no rows returned';
}
[/code]

EDIT: The error actually implies something else has gone wrong with your query. You shouldn't be getting that error.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.