ok , I get the schema you propose. didn't get the part of having one products table, so having one table is ok? overall I'll have 3 tables, one with users , one with products and one storing their ids? is that right?
don't know why I thought mysql didn't support foreign keys
Search found 5 matches
- Wed Aug 20, 2008 10:06 am
- Forum: PHP - Theory and Design
- Topic: Complex project
- Replies: 10
- Views: 1344
- Wed Aug 20, 2008 8:37 am
- Forum: PHP - Theory and Design
- Topic: Complex project
- Replies: 10
- Views: 1344
Re: Complex project
hey thanks for reply. really appreciate it. ok but I am a bit lost. firstly I am using mysql, so no foreign key. I came up with 2 plans from looking at your message. plan 1. user logs in and is presented wih for example - category gaming and subcategory -psp-xbox-ps3. ok all products are stored in a...
- Sat Aug 16, 2008 7:54 am
- Forum: PHP - Theory and Design
- Topic: Complex project
- Replies: 10
- Views: 1344
Re: Complex project
yeah basicly, but there a looooot of categories, so that's why I am wondering wats the most efficient way, maybe creating a table for each user?
- Fri Aug 15, 2008 6:42 pm
- Forum: PHP - Theory and Design
- Topic: Complex project
- Replies: 10
- Views: 1344
Re: Complex project
basicly the layout, if a user chooses 5 different products, from 5 different tables, should I store search queries for each user in a table? right now I have a table for each category example: tblgaming with columns like brand and name, then I must display those products to users who register for ga...
- Fri Aug 15, 2008 10:13 am
- Forum: PHP - Theory and Design
- Topic: Complex project
- Replies: 10
- Views: 1344
Complex project
hey, I am busy with this project, the owner wants users to select which products they want to receive updates, basicly a business adds a product, and users can be notified of that. I am a bit stuck on the design since there is a lot of categories a user can subscribe too , any ideas on what is the b...