error: Supplied argument is not a valid

[run2web]

I keep getting this error and I cannot figure out why...

WARNING: Supplied argument is not a valid MySQL result resource

Here is the snippet of code that it is calling the error on.

$query = ("SELECT * FROM $table WHERE Stock_number LIKE '$Stock_number%' Category LIKE '$Category%' AND
Manufacturer LIKE '$Manufacturer%' AND Make LIKE '$Make%' AND Fuel_type LIKE '$Fuel_type%' AND Slide_outs LIKE '$Slide_outs%' AND Primary_image LIKE '$Primary_image%' AND Other_image1 LIKE '$Other_image1%'");

$result = MYSQL_QUERY($query);

if (!$result) print ("failed 2\n");
/ Determine the number of records returned /

this line==>>>>>WHILE ($row=MYSQL_FETCH_ROW($result))
$number = mysql_num_rows($result);
if (!$number) print("failed 2 \n");
/ Print the relevant information /
$i = 0;

[[deleted]]

Your query is not valid. Print the query before you execute it, and print mysql_error() to get more info about what the error was.

[Anon]

you'll need,

$db=mysql_connect("host","user","pass");
mysql_select_db("databasename");

and then for query -

$result = MYSQL_QUERY($query,$db);

also make sure $table is correct.

[Anon]

$query = "SELECT * FROM $table WHERE Stock_number LIKE '$Stock_number%' AND Category LIKE '$Category%' AND
Manufacturer LIKE '$Manufacturer%' AND Make LIKE '$Make%' AND Fuel_type LIKE '$Fuel_type%' AND Slide_outs LIKE '$Slide_outs%' AND Primary_image LIKE '$Primary_image%' AND Other_image1 LIKE '$Other_image1%'";

[run2web]

Thank you, that worked perfectly!

pyroxpro.com wrote:

$query = "SELECT * FROM $table WHERE Stock_number LIKE '$Stock_number%' AND Category LIKE '$Category%' AND
Manufacturer LIKE '$Manufacturer%' AND Make LIKE '$Make%' AND Fuel_type LIKE '$Fuel_type%' AND Slide_outs LIKE '$Slide_outs%' AND Primary_image LIKE '$Primary_image%' AND Other_image1 LIKE '$Other_image1%'";