Search found 5 matches

by mosquo
Wed Aug 20, 2008 10:06 am
Forum: PHP - Theory and Design
Topic: Complex project
Replies: 10
Views: 1344

Re: Complex project

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
by mosquo
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...
by mosquo
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?
by mosquo
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...
by mosquo
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...