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