i use eclipse (http://www.eclipse.org/) with php, web development, database, and svn plugins. i edit php files that generate xhtml, rss, xml, and css as well as css, js, and sql files (the sql files are just create table statements so i can see how my tables are set up).
it's free, multi-platform (i use it on both linux and windows), and supports phpdoc for the functions in my php libraries, and can also autocomplete things i'm typing for me. it probably wouldn't help much for somebody who doesn't know what they're doing and just wants to throw a static site out there as quickly as possible, but it's perfect for somebody like me.
track7 - my dream-hosted site