Need to get some advice on the best way to store/structure (one to many) in mysql using php.
I have a products table like this:
p_id p_price p_name p_supplier
I created a seperate table to store category names:
my problem is with the category, a product can be assign in to many categories so what is the best way and how to store the products in the categories?