On 5/15/07, Mark Armendariz <[EMAIL PROTECTED]> 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/
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
