Mike Kruckenberg has this post over on his blog today with his take on MySQL and PHP: Best Practices.

Jim Winstead speaks about good practice for MySQL and PHP at MySQL 2004. Looking down this it appears that I've just duplicated Jim's slides, not sure how much value that adds if you can just go an get the slides yourself.

Some of the items he mentions include things we've all heard over and over:

• don't trust user data
• watch for SQL injection points
• benchmark overall page load times
• don't use * (asterisk) in SQL selects
• use the right storage for the right data (i.e. don't put files in the database)
• and much more...

Check out this post for the full list...