Query Help

[charlielha]

Hello,

I am using the following query:

$thewho = $row_rsSubcategory['sub_name'];
mysql_select_db($database_products, $products);
$query_rsProduct = "SELECT * FROM items WHERE product_subcategory LIKE '%".$thewho."%'";

the recordset Subcategory is defined earlier.

This query works fine,

However on my database under the product_subcategory I have for example:

chair - occasional.

If a person goes to chair, the query finds all the products with chair on their subcategory.

But if a person goes to occasional, the query doesn't find anyhting.

Any idea on how to make this query work?

Thanks

[dreamcatcher]

Welcome to Webmaster World. I think you might need to post us some more of your code, so we can see what exactly you are doing and where the problem lies.