|
hello reader..
i'm bulding a website having a product page. Categories in the Product page include; pet, gardening and food.
I'm thinking of getting user preferences via registration form where by he can tick any categories of product that suit his preferences through check boxes. For example, if he ticks pet & gardening, products images & info about pet & gardening will appear in the Product page. But if the user is not a registered user, products about pet, gardening & food will appear randomly in the Product page.
Should i create only 1 table consist user information & preferences or 4 table ( user, pet, gardening and food).. I'm using php and mysql for the project. Anyone plz help me. Stuck for days...
| 
