[SOLVED] Double Join

[scottybwoy]

I have a query :

SELECT p.products_id, p.products_model, p.products_image, p.products_price
FROM products p INNER JOIN products_to_categories ptc
ON ptc.products_id = p.products_id
WHERE ptc.categories_id = " . $n_cat_row['categories_id'] . "
AND p.products_status = 1
ORDER BY p.products_ordered DESC LIMIT 1

 

Can I also get data from another table `products_description`.  In this table it has the columns `product_id`, `products_name` and `language_id`.

 

So I want to pull `products_name` ON `products_id` WHERE `language_id` = LANGUAGE_ID.

 

How do I go about integrating that into my original query?

 

Thanks

[Mchl]

You can. Add another INNER JOIN after

ON ptc.products_id = p.products_id

[scottybwoy]

Like :

SELECT p.products_id, p.products_model, p.products_image, p.products_price, pd.products_name
FROM products p INNER JOIN products_to_categories ptc
ON ptc.products_id = p.products_id INNER JOIN products_description pd
ON pd.products_id = p.products_id
WHERE ptc.categories_id = " . $n_cat_row['categories_id'] . "
AND p.products_status = 1
AND pd.language_id = " . (int)$languages_id . "
ORDER BY p.products_ordered DESC LIMIT 1

?

[Mchl]

Yeah. Should work

[scottybwoy]

No it doesn't

 

I echoed out the statement and the variables are correct, I ran it through phpMyAdmin, and it didn't like it there either.

[Mchl]

And what did it say?

[scottybwoy]

Sorry my mistake.  It did miss one $var that messed it up.  Cheers for your help