Mysql_fetch_assoc() error

[ojef1]

mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\eclipse\test\mysql.php on line 14

 

this is the error I get if I comment out the if statements. With the If statements I get "query failed"

 

I have to assume the problem is with $extractQuery or $extract ... I just am at a loss for what the problem could be

 

thanks

 

$connect = mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("Pickem", $connect) or die(mysql_error());

//extract data from key table
$extractQuery = "SELECT * FROM key ";
$extract = mysql_query($extractQuery, $connect);

if ($extract) {
if (mysql_numrows($extract)) {
	echo $extract;
	print_r(mysql_fetch_assoc($extract));
}
else {
	echo "no results found";
}
}
else {
echo "query failed";
}

[spiderwell]

key is a reserved word, put it in backticks `key`

[ojef1]

thank you sir