Error is: "Query was empty"

[viper139]

At first I was getting this error

"Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in"

but then I added the code

if (!$result) {
die("Error<br />Query is: $sql<br />Error is: ".mysql_error());
}

I now I get the new error

"Error
Query is:
Error is: Query was empty"

I'm sure this is somthing simple I just can't figure it out 🙁

Here is my code

<?php

$k = $_GET['k'];

$terms = explode ("  ", $k);
$query = "SELECT * FROM a7526299_product WHERE ";

foreach ($terms as $each) {
$i++;

if ($i == 1) 
     $query   .="keywords LIKE '%each%' "; 
else 
     $query   .="OR keywords LIKE '%each%' ";
}


// connect 
mysql_connect ("-------", "-------", "------");
mysql_select_db("a7526299_product");

$query = mysql_query ($query);
$result = mysql_query($sql);
if (!$result) {
die("Error<br />Query is: $sql<br />Error is: ".mysql_error());
}
$numrows = mysql_num_rows($query);
if ($numbers > 0) {

while ($row = mysql_fetch_assoc($query)) 
{
	$id= $row['id'];
	$id= $row['Brand'];
	$id= $row['Description'];
	$id= $row['Category'];
	$id= $row['Price'];
	$id= $row['Image'];

	echo "$id, $Brand $Description, $Category, $Price, $Image"; 


}
}
else 
	echo "No results found for $k";
// disconnect 
mysql_close(); 
?>

[NogDog]

Welcome to the forums. 🙂

In the future, please wrap your PHP code snippets in [noparse]

...

[/noparse] bbcode tags to make them more readable.

As to your problem, it appears to be here:

$query = mysql_query ($query);
$result = mysql_query($sql);

I think you want to replace those 2 lines with this 1 line:

$result = mysql_query($query);

[viper139]

Thanks for the quick response, I've been stuck on that for hours 🙂

I'm now getting the error

Error
Query is:
Error is: Table 'a7526299_product.a7526299_product' doesn't exist

which is very annoying.

heres a picture of myphpadmin

Any ideas?

[viper139]

I thought that too, but when I change the db name to Product my error changes to this instead

Query is:
Error is: Table 'a7526299_product.Product' doesn't exist

[cretaceous]

you should do a select using a table name - not the database name - so in your case:
"SELECT * FROM Products WHERE ";

[viper139]

Oh wow I just realised is Products with an s, lol onto the next error.

now I'm getting

Query is:
Error is: Unknown column 'keywords' in 'where clause'

Can i fix this by adding another column onto my database with keybwords for each item?

[vivek151189]

Unknown column 'keywords' in 'where clause'

as the error suggest there is no column like 'keyword'