[SOLVED] supplied argument is not a valid MySQL result resource

[mbrown]

		$result = mysql_query($Query, $db);
		$WASD = mysql_fetch_assoc($result);

 

Error Messages for the Above Code: Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\seniorProject\administration\showEquipmentData.php on line 141

 

			$numRows = mysql_num_rows($result);
			if ($numRows <= 0)

 

Gives the following error: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\seniorProject\administration\showEquipmentData.php on line 162

 

I am going to still mess around and research some to see if ic an find a solution. If anyone else knows what it is please let me know please.

 

Thanks

[/code]

[gevans]

change;

 

$result = mysql_query($Query, $db);

 

to;

 

$result = mysql_query($Query, $db) or die(mysql_error().'<br /> the query: '.$Query);

[omfgthezerg]

This means your query is failing.  Check your query:

$result = mysql_query($Query, $db) or die(mysql_error());

[mbrown]

Fixed. Did a combination of what you two said about 5-10 minutes after I posted. All working now.