Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    3

    Unanswered: MySql select with three tables problem

    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

  2. #2
    Join Date
    Aug 2004
    Location
    France
    Posts
    754
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •