Keith Devens .com

PHP and Database tips

There are some relatively good PHP tips at PHP Builder (via PHPEverywhere), and a pretty good article on data normalization there too. Turns out I've been using fourth normal form regularly Though both articles have an extraneous field in their fourth normal form table examples... you don't need the relationId here, and both the relatedUrlId and the relatedUserId should be a combined primary key. His table naming sucks too I find it's helpful, with a many to many relationship, to have table names like (using his example tables): Users, Urls, and User_Urls. It makes it clear what you're relating together.

Permalink | Comments? | Tags: Programming | id 3166

02:03 (utc-5)
edited: 02:07 (utc-5)