Always read through your code before committing.

RTFM

DRY (Don't repeat yourself) and KISS (Keep it simple, stupid). These have saved me from having to spend hours and hours of maintenance to change or add features.

if possible start a transaction before writing a query :)