Supplied argument is not a valid MySQL result resource

[BigBadDave]

My code worked fine on server A then i moved it to server B and it stoped working and I got this error :


Warning: Supplied argument is not a valid MySQL result resource in /usr/home/m/a/markszone/public_html/shop/search.php on line 24


any ideas?? Regards

Big Bad Dave

flashtektips@hotmail.com

 

[phpPete]

Means your mysql_query() is bombing.

So, something you're passing there is not kosher.

Check your passwords, servername, query syntax

 

[sleipnir214]

You should never see that error. If you do, it means you aren't doing enough error checking in your code.

This code sample that follows shows the error checking and error reporting I recommend you perform. It will also perform the first two troubleshooting steps I recommend you take when you dealing with MySQL calls: displaying the query and displaying the error from MySQL.

[tt]

$dbh = mysql_connect ("myserver", "myuserid", "mypassword");

if ($dbh !== FALSE)
{
	$result = mysql_select_db ("mydatabase", $dbh);
	if ($result !== FALSE)
	{
		$query = "SELECT myfield FROM mytable";
		$rh = mysql_query ($query);
		if ($rh !== FALSE)
		{
			while ($myrow = mysql_fetch_array ($rh, MYSQL_ASSOC))
			{
				// process the data returned from the database.
			}
		}
		else
		{
			print $query;
			print &quot;<br>&quot;;
			print mysql_error();
			die();
		}
	}
	else
	{
		print mysql_error();
		die();
	}
}
else
{
	print mysql_error();
	die();
}

[/tt] ______________________________________________________________________
TANSTAAFL!