This is not directly a MySQL question but I am using PHP and MySQL for this project so here is my question . . .

I'm new to designing databases and this is the problem I face. In my database I have a table called PRODUCTS with fields such as Name, Description, and Price. Users will be adding their products via PHP scripts to the database. However, some products may need additional "custom" fields that we may not know about ahead of time such as size, length, colors, or any others that someone may need sometime down the road. How do I set up the database in advance to account for people adding products that may need some "custom" fields?

Forgive me if this is too vague or elementary or for most of you but after reading through the archives I found some similar information and thought you guys wouldnt mind helping a new guy out.

Thanks,

Dave

--

--------------------------------------------------------------------- Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail mysq...@lists.mysql.com

To unsubscribe, send a message to: <mysql-unsubscribe-lancelot_=sdne...@lists.mysql.com>

If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php