Basic html pages – I used Dreamweaver. And Dreamweaver kind of manages the site – although is prone to putting folders in the wrong place. CuteFTP is a good backup if Dreamweaver goes wrong. CuteFTP is also much much quicker at file transfers between local machine and the remote site at Dreamhost.com.
Php pages. I tried Apatana studio but its too buggy. Ultra Edit and/or UEStudio does nice color-coding for php.
Stylesheets – the CSS is edited in Stylemaster – not Dreamweaver if I can help it.
Mysql – the databases are edited in the browser at mysql.madpride.org.uk using phpmyadmin. That’s fine.
On my local machine I have two versions of the madpride site. One is on C:\Apache2.2\htdocs\madpride. And the files there I keep synchronized with the files on Dreamhost. However this local site doesn’t work on my local server properly because the settings are geared up for Dreamhost (i.e. the databases referenced are at Dreamhost and not my local mysql.
The other version is at C:\vhosts\dev.madpride. And because I have virtual hosts enabled – I can simply access the site locally by going to http://dev.madpride with the browser and it works properly. But because the settings are geared towards local use, these files are not synchronized with those on Dreamhost. This however is the development site – where I can test out all new pages and new technologies before they go live.