In addition to the purchased list, we want to have a "with list" kind of feature where you could add and remove things you might want to buy... So we would need to have some kind of array for each user that lists the ids of the puchasable items, that can grow and shrink...
Any ideas? Thanks. On Wednesday, November 28, 2001, at 03:58 PM, Christopher R. Jones wrote: > My suggestion is two tables: > Users: > user_id, name, email, phone, etc. > > Purchases > Purchase_id, user_id > > The link is the user_id field. I am not sure why the purchased items > would shrink with time. Once a purchase is made and recorded, why > would it disappear? > > >> I'm new to MySQL and i'm having some trouble with creating a table >> with the format i need. >> >> I need to create a table for user information (name, email, phone) and >> a list of purchased items (IDs) that will grow or shrink with time, in >> some kind of dynamic array. >> >> Is it possible to have this in one table, or would the purchased items >> need to go in a seperate table, for each user? I haven't used indexes >> yet, could those be usefull in this case? -------------------- Chris Comeau [EMAIL PROTECTED] --------------------------------------------------------------------- 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