Coding in Windows & running from linux

[jcr1]

I am very new to this and want to learn PHP etc.
I have a linux computer running Debian Sarge, set up as a server. I have done a bit of coding on it and can view the result in a browser  opened on my WinXP machine.
How can I do the coding in an editor (and what would be a good editor(s)) to use, on the windows machine with the result saved into the appropriate directory, on my linux machine.
I have quite a good network setup and currently use PuTTY to work on the linux machine, but the console is hard going and I feel there must be something better. I also use Filezilla to get stuff across to linux and it works extremely well for what it does too.
The Debian installation is non-graphical and I would prefer to keep it that way and keep the windows machine for any GUI stuff.
Sorry if this sounds a bit of a ramble but I am very interested in getting into this and if I could get some help and direction I would be very grateful.

[jcr1]

I've finally worked it out.
I tried ESftp with Eclipse; couldn't get it to work.
Then I got onto a program called sftpDrive, which works very well, kind of like samba, it allocates a drive e.g. e:, f:, etc. to linux and you have the choice which directories you want. I can then pick up which PHP file I want and open it in Eclipse to work with. Very slick  
Downside is, its only a 6 week trial and at the end of it, it will cost $39 if I wish to keep using it.
Now all I have to do is find out how to do a similar thing with MySQL

[admin]

putty and filezilla is what I use. You could also try any one of the rsync variants -- which synchronize files and directories from one location to another.

[jcr1]

Thanks admin,
As I said I'm very new to this.
putty and filezilla sound like a nice clean option.
Can you tell me which directory I would find created databases in please?
Currently my PHP stuff is in /var/www/WEB/ (set up like this on advice from my son).
I have installed TOAD MySQL on windows but I think I need to provide more info to get it to work i.e. path to database files?

[admin]

Maybe under /var/lib/mysql

You can also try any of the VPN programs...
http://www.hamachi.cc/