ok this works now, thanks

but this error # 2002 is still bugging me. I noticed this though.

As I am hosting 2 sites at different hosting server. I tried to connect to my
MySQL database in the other site and it works fine. When I login into
PHPMyAdmin I see that the Server is "Localhost via UNIX socket" so I put that
into my setting in dreamweaver for the "MySQL server" but on the hosting that
giving me that #2002 error message their Server is "127.0.0.1 via TCP/IP" and I
tried to put in 127.0.0.1 instead of localhost but it still doesn't work and
gives me this error message. I have asked them to upgrade me to php version 5,
do you think this will help solve the issue? or is it because it is hosting in
a windows server?