Re: [PHP-DB] Split Fields into 2 Tables or All in One?

2002-07-26 Thread Rick Widmer
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

[PHP-DB] Split Fields into 2 Tables or All in One?

2002-07-25 Thread Monty
In setting up a member table in MySQL, I'm not sure if I should include all fields in the table or only the most common fields, leaving things like address fields to be placed in another table being that members aren't required to provide mailing address info and these fields may be mostly blank