What does this error mean?

jacksonpt

I got this error this morning, but I'm not sure exactly what it means. I guess my question is: What exactly does it mean by "result resource"? Any help is appreciated.

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Apache\Apache2\htdocs\4ROC-NY\ShowMemberDB.php on line 33

No records were found!

and here's the php that causes it:

$result = mysql_query("SELECT * FROM members",$db);
if ($record = mysql_fetch_array($result)) {

bad76

Hi,
look mysql_error() function.

LordShryku

Whenever you use mysql_query, it creates a resource id to execute the query. That error means that the resource is invalid, so you're going to have to throw some error reporting in to find out where it's going wrong.

$conn = mysql_connect("","","");
if(!$conn) {
   die("Cannot connect");
}

$db = mysql_select_db("",$conn);
if(!$db) {
   die("Cannot select DB");
}

$result = mysql_query("SELECT * FROM members") or die(mysql_error());