Ideally, you will want at least 2 tables. One for user info, and another for purchase information. One easy way to think of database normalization is to make sure that each table only has one purpose, ie user information. (Obviously, for security reasons, you would want to remove credit card info to another table, but the example is still accurate.)
Steve ----- Original Message ----- From: "Chris Comeau" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, November 28, 2001 12:06 PM Subject: Dynamic arrays in table? > 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? > > Thanks. > > -------------------- > 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 > > > > --------------------------------------------------------------------- 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
