I want to know what kind of normalization to use to solve and retrieve data
for this SQL based application:
Following descritpion is the way I can do it.
I want to store data about contacts :
-> table Contacts(ID,Name,EMail)
and data about list of users :
-> table Lists(IDList, ListName)
I want to be able to create list of list of users....
e.g : men -> 20-35 -> ComputerRelated -> John Doe, Mike Smith
e.g : ComputerRelated -> John Doe, Patti Young, Mike Smith
I put contacts into lists using 2 others tables:
-> table1 (IDList,IDContact)
-> table2 (IDMotherList,IDDaughterList)
In there any way to do somehting else....cause retrieval query seems to be a
bit
tricky this way ??
ANy ideas .
Thanks.
Xavier
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
