Database

I am going to have a MySQL database, I need to make it so that it updates itself against a server when it comes in contact with an internet connection. Is this possible to do?

Yes, it is possible, but what do you mean by update itself?
do you want to synchronise it to a remote database?
If you can get the appropriate access to the remote database you could just download it and replace the local database, if that would suite your needs...

yes, but i need it to be automatic, what would i use to do that?

Before you design the application you need to think of a couple of things.

1: what protocols can you get access to download this database with, FTP? HTTP?, A safer way of doing this would be to let the server upload the file to the local comp, that way if more than one computer needs to be updated, thay can be done at the same time...
2: Will this change in the future, IE you might want to consider giving the user the ability to set the URL to the database and the protocol in which to download it.
3: What about security, user name/passwords?

The web client control makes it stupidly easy to download a file...
I have made a simple file downloader, which supports resume so I will upload that, or if you can read C#, I pretty much copied and converted it from a download manager article on the code project