Not a valid result resource; what?

[Sartavius]

Okay, I have a table with two columns..'annoyed' and 'ignored'. I poulated 'annoyed' with Bob and 'ignored' with Sally. I ran the following test due to problems I was having in my main script and I get the old MySQL "Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home2/testing_ig.php on line 16

Here is the code:


<?php
$DBhost = "localhost";
$DBuser = "xxxxx";
$DBpass = "xxxxx";
$DBName = "xxxxx";
$table = "ignore";

mysql_connect($DBhost,$DBuser,$DBpass) or die();
@mysql_select_db("$DBName") or die();

$ignorequery = "SELECT * FROM $table WHERE annoyed='Bob' AND ignored='Sally'";
$checkignore = mysql_query($ignorequery);
$ifignored = mysql_num_rows($checkignore); //<--- This is line 16

if ($ifignored >= 1) {
echo "exists";
} else {
echo "doesn't exist";
}
?>


I must be really tired because I'm not seeing the problem...?

[Sartavius]

LOL, nevermind. Forgot that ignore was a reserved sql keyword.

[traq]

LOL, nevermind. Forgot that ignore was a reserved sql keyword.
:D use your backticks...
SELECT `col` FROM `table` WHERE `col`='value'usually unnecessary, but sometimes they solve problems and never cause any