Victor, > That strikes me as messy. Each tmp table has as many rows as necessary for > the products that are to be bough. To do as you say I would have to create a > table with a zillion rows to accommodate however many products I *predict* > buyers would buy. Therefore, I guess I should probably create a new database > so as to not make a mess of the main database.
You fundamentally misunderstand relational database design. I suggest reading this book: http://www.xaprb.com/blog/2009/08/22/a-review-of-beginning-database-design-by-clare-churcher/ Regards, Baron -- Baron Schwartz Percona Inc: Services and Support for MySQL http://www.percona.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org