Help with a sql query

[batteryman]

Hello,

I need to select all products from a certain category out of my current database to export to another database.

How do I make the mysql query do it


This is what I was thinking but didnt work:

SELECT * ROWS FROM `zen_products` WHERE `master_categories_id` = 69

All Im trying to do is select all products that are in master category 69

Im sure this is really wrong however this is my first attempt at mysql syntax.

[batteryman]

I got:

SELECT `master_categories_id` = 69 FROM `zen_products`

which got me closer I think, meaning i didnt get an error but still quite right.

[DrByte]

SELECT * ROWS FROM `zen_products` WHERE `master_categories_id` = 69

remove the word ROWS, and you'll get all the meta information about your products, but without descriptions

If you want descriptions too, use:

select p.*, pd.* from products p, products_description pd where p.products_id = pd.products_id and p.master_categories_id = 69;

[batteryman]

If you want descriptions too, use:

select p.*, pd.* from products p, products_description pd where p.products_id = pd.products_id and p.master_categories_id = 69;

I had to change your sql to include my prefix zen_

select p.*, pd.* from zen_products p, zen_products_description pd where p.products_id = pd.products_id and p.master_categories_id = 69;

Which then produces the result:

MySQL returned an empty result set (i.e. zero rows). (Query took 0.0010 sec)

So what do you think I should do, also what is p. and pd. and how do they represent what they represent?

I have seen those called in another module and wondered what they were then as well.

[DrByte]

if you're getting 0 results, then you have nothing matching the master-categories-id = 69.


The p. and pd. are table-aliases... note "products p, products_description pd" ... that's where the aliases are defined.

[batteryman]

if you're getting 0 results, then you have nothing matching the master-categories-id = 69.


The p. and pd. are table-aliases... note "products p, products_description pd" ... that's where the aliases are defined.

Im feel so stupid right now, I was running the query in my new install. OOops!

Thank you Dr. Byte

[batteryman]

Oh, big question,

Because I used the query you suggested where the product and description are displayed together in the results. How do I import this information into a new database so that the information goes into its table?

[BWB]

I too have a SQL question. I need all (Several) Order Product Attributes to be in their own field and Exported to CVS. I know how to Export using MyPHP but I don't have enough SQL knowledge to combine all the OrderProductAttributes to one line for each product ordered.

[batteryman]

I too have a SQL question. I need all (Several) Order Product Attributes to be in their own field and Exported to CVS. I know how to Export using MyPHP but I don't have enough SQL knowledge to combine all the OrderProductAttributes to one line for each product ordered.

What are the tables you want to export from and what are the fields you want included??

[BWB]

What are the tables you want to export from and what are the fields you want included??

The file is Orders_Products_Attributes and the fields are
orders_id orders_products_id products_options products_options_values The problem is I have several options and option values for products but need all of them on separated on a single row per order/product. And to make things worse there can be the more than one of the same product with different attributes per order.