SitePoint Sponsor  User Tag List  Page 2 of 2 FirstFirst 12
Results 26 to 27 of 27   1. #26     SitePoint Wizard co.ador's
Avatar     Join Date     Apr 2009     0 Post(s)     0 Thread(s)
Man, I am a shame that I couldn't understand the first tiem it
is clear Now I will make an extra effort to avoid you coming to
simple language. I understood it I just need to add the other
condition to the JOIN.     WHERE category_id = ".$idc."     As
you were going to the steps in the last post, I wonder why not
AND instead of WHERE in the INNER JOIN after ON. It seems that
the language has change.      FROM products INNER JOIN
categories     ON = products.category_id     WHERE category_id =
".$idc."     Why not      FROM products INNER JOIN categories
ON = products.category_id     AND category_id = ".$idc."     it
just a question Mr.      From what I understand AND means that
both of the conditions need to be true = products.category_id
AND category_id = ".$idc.".      Now I can see you have put
WHERE what's is the