Multiple queries for same table

[Anon]

I on occasion have problems when I am trying to query several different queries from the same table at different locations within the page. for example the problem I am having now is that,

I have a products page where the detail info on a product comes up (middle page) within that I also have a query for the options of that product ex (where optionsku = productsku) options have a separate table.

When I added a query to list all the products on the left side as a navigation (names only) it screwed up my option query. Depending on how I play with it, it either brings all the options in the options table or; if there are 3 option values (red,green,blue) for a product and there are 10 products, it will display 10 red, 10 green and 10 blue options?

I know it has to do with cross querying, but I am sure there is a way to solve. any help will be greatly appreciated.

Thanks,

Brett Taylor

[Anon]

i think you should try a left or a right join. 🙂
See www.mysql.com for documentations about the join syntax.

--
Martin

[btaylor]

Martin,

thank you, I was able to get it to work.

Bret