Re: Split Fields into 2 Tables or All in One?

From: Date: Fri, 26 Jul 2002 20:52:00 +0000
Subject: Re: Split Fields into 2 Tables or All in One?
References: 1 2  Groups: php.db 
Request: Send a blank email to php-db+get-20827@lists.php.net to get a copy of this message
At 02:18 PM 7/26/02 -0400, Monty wrote:
Anyone have any tips or links to tips about update multiple tables based on data received from a form?
If you use varchar fields the cost of empty fields is very small. The decision on using a separate table should be based in things like how many addresses you allow someone to enter. If you allow zero or one address per entry go ahead and put it in one table. If you want to allow zero or more phone numbers that would call for a separate table with the number and type of phone. Rick

« previous php.db (#20827) next »