[agairob]

I have a tricky query, and I can’t go around it. Please give me a hint on how to do this correctly. I want to select count everything from the following tables.
Here are my tables:

Categories:
Categoryid, category, description, orders, avail, image

Products:
Productid, product, model, brand, weight

Product_categories:
Prod_cat_id, productid, categoryid

Now here is the query
“select count(*) from product_categories, categories, products where product_categories.categoryid=categories.categoryi d and product_categories.productid=products.productid and categories.category like $some_category";

What am I doing wrong, I get INVALID SQL: 1064 error
Any help will be appreciated

[RBARAER]

Hello,

It may not be that, but it seems you have a space that should not be in your where clause :

product_categories.categoryid=categories.categoryi d

Regards,

RBARAER