[SOLVED] MYSQL NEWCOMER HELP

[lill77]

Hello can somebody help me please. . .

 

I have created 2 tables in my phpMYADMIN im in version MySQL client version: 4.1.22.

 

I have attached the two tables, I want to know if I can select info from them two ways by cat which will be make eg Ford, and by product eg Window or horn . . .

 

Thanks

 

 

[attachment deleted by admin]

[waynew]

SELECT * FROM category

SELECT * FROM products

[revraz]

What field in product?  Would it be Description?

 

You can find a word in the description by using LIKE '%window%' and then you can join the two tabes if you need the category from the category table.

[lill77]

Thanks would that be someting like

 

$query = "SELECT * FROM `products` ORDER BY 'CAT' ASC";

 

an

 

$query = "SELECT * FROM `category` ORDER BY 'CAT' ASC";

 

?

[lill77]

Im getting myself confussed. I need to save products by two ways cat and by product so it would be a  Cushion that belongs to say . . M&S. So then I could pull the info in by product eg cushion and or by M&S.

 

Thanks

[revraz]

You only save it one way.

 

You have two tables, one that has your Category Name with a ID, and one that holds Products.

 

Your Product holds the category_id it belongs to.

 

So you really only need to query the product table, and join the category table if you want the category name.

[lill77]

Great thanks i WILL see how I go

!

[lill77]

Hello im back again.  So I gather that i can show products by type eg duvet set or fleece or pillow etc... and also show by make of the product, with the way im saving the info in my database.

 

Thanks

[revraz]

You can show it by any field you desire.

[lill77]

Thanks

 

It is better the save the info into a field that is most common eg product, and then search by make ? Do you know of any links to how to do this eg. help or tutorial ??

 

Thanks for your help

 

Rich

 

[revraz]

See if this helps

 

http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html

[lill77]

thanks again

 

Rich