Re: [PHP] key pairs

[Rick Widmer]

At 04:44 PM 12/17/02 -0500, 1LT John W. Holmes wrote:

What I was thinking is that you have one table with

Order_ID
Name
Address
Flag -> Here you flag this as SHIP_TO or BILL_TO
etc...


That layout would be better than:

Order_ID
Ship_name
Ship_address
Bill_name
Bill_address
etc...

Which is what I got from you last email.

Does anyone agree?

Not only do I agree, so do the people who came up with the rules of proper database normilization. Here are a few of the top results on a Google search for database normalization.


http://www.phpbuilder.com/columns/barry20000731.php3?page=1

Watch how he handles URLs.


http://www.devshed.com/Server_Side/MySQL/Normal

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=4887&pg=1


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php