I might as well chime in...
Komodo Edit (Free, as opposed to Komodo IDE) for PHP, JavaScript, Perl, and of course silly old HTML/CSS. Supports SFTP/SCP copying to/from the hosting server for SECURE transfer, as well as the insecure FTP method. Also supports Ruby, Tcl/tk, Python, C, C++, Java and other, more obscure coding formats for both context-sensitive help, functions, and colorization.
Paint.Net for picture editing.
I've also used Dreamweaver and Adobe Photoshop Elements ($100 vs. $2500, and has the most common tools you'd need) for some work, but I'll agree with many other posters - Dreamweaver adds way too much extra, unnecessary code.
For database configurations, I use MySQL and the MySQL Query Browser to set up my tables, and whatnot. There's also an MySQL visual data modeler that allows you to make awesome relational db diagrams and then export them as create scripts called
MySQL Workbench. There is a free open-source version available.