NYCPHP Meetup

NYPHP.org

[nycphp-talk] Flexible Forms & How to store them...

csnyder chsnyder at gmail.com
Tue May 15 14:06:13 EDT 2007


On 5/15/07, Mark Armendariz <lists at enobrev.com> wrote:

> CREATE TABLE data_fields (
>         field_id MEDIUMINT(6) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
>         data_id TINYINT(3) UNSIGNED NOT NULL,
>         field_name VARCHAR(20),
>         field_data VARCHAR(100)
> )

Did you ever worry about record integrity problems?

What if a data record is missing some field values? Or has more than
one value stored for some field name?

I was glad to see Brian asking about this topic, because it's been
sitting in the back of my head for a while now.

-- 
Chris Snyder
http://chxo.com/



More information about the talk mailing list