Re: key pairs

From: Date: Wed, 18 Dec 2002 00:10:35 +0000
Subject: Re: key pairs
References: 1 2 3  Groups: php.general 
Request: Send a blank email to php-general+get-128634@lists.php.net to get a copy of this message
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

« previous php.general (#128634) next »