Need help w/ SQL query in phpMyAdmin

[audradh]

Hmmm, can anyone tell me what is wrong w/ this:

SELECT products_description.products_name, products_description.products_description, products_description.products_id, products.products_image, products.products_price_sorter
FROM products_description, products
WHERE products.products_status = "1"

This gives me the same name, description and id attached to each different image, price_sorter, then the next name, description and id attached to each different image, price_sorter, then the next, etc.

Thanks for any help! I'm off to bed for now.
Audra

[hugo13]

Hmmm, can anyone tell me what is wrong w/ this:

SELECT products_description.products_name, products_description.products_description, products_description.products_id, products.products_image, products.products_price_sorter
FROM products_description, products
WHERE products.products_status = "1"

try this one

SELECT products_description.products_name, products_description.products_description, products_description.products_id, products.products_image, products.products_price_sorter
FROM products_description INNER JOIN products ON products_description.products_id = products.products_id
WHERE products.products_status=1

you have forgot the join statement :: http://dev.mysql.com/doc/refman/5.0/en/join.html

[audradh]

Worked a charm, thanks hugo!

I'll have to really look at Join Statements. That might take me a little bit to digest.

I have managed to expand it to find only the products on special by doing this:

SELECT products_description.products_name, products_description.products_description, products_description.products_id, products.products_image, products.products_price_sorter
FROM products_description
INNER JOIN (
products, specials
) ON ( products_description.products_id = products.products_id
AND specials.status = "1"
AND products_description.products_id = specials.products_id )
WHERE products.products_status =1

Now to pull products on sale, must be similar but using master category ids.

And lastly to pull everything not on sale/special, hmmm, not sure how that will work. Any thoughts?

[schoolboy]

All this would be easier if you used phpMyAdmin...

[audradh]

Funny, I actually am doing this in phpMyAdmin, but I'm not familiar w/ using the query tab either and couldn't seem to find what I wanted. Either way had a learning curve for me, but now that I've gotten this far I can see that the join portion might have been easier that way...but then I wouldn't have learned as much! Perhaps it will help me w/ this next portion though.

Thanks
Audra

[schoolboy]

Apologies Audradh... I see that you are using phpMyAdmin... why not just use the EXPORT features there?

... or is the export you want more specific and custom?

[audradh]

Yes, I'm trying to pull only specific information for a data feed, so I don't think the Export tab will give me what I am looking for.