frustrated

Nice, that helps a lot. I read the page you linked to. It would be nice to use that method but I don't think I have enough control over the database to do something like. I have no money and can only afford shared hosting

Ok...I'm trying to insert the time into a database using the mysql NOW() function, but I wanted to offset the time to my actual time zone. For instance, the server the site is hosted on is in California, but I live in New Hampshire. I want the time in the database to reflect New Hampshire time as opposed to California time...it's like a 3 hour difference. My inclination was to do something like this $time_offset = /* Would equal the difference in time */ $sql = "INSERT INTO the_table (the_date) VALUES ((NOW() - $time_offset))"; Am I on the right track or is this not even possible with the NOW() function...or not possible at all? Thanks for any help.

Yea ideally it would be nice if both the sites were hosted on the same server, but these aren't my sites and the owner has each site through a totally different hosting company...why...I don't know. I created a simple shopping cart for this person where they go into an admin area to add products. My hope was that they could go into the admin area through the .com site, add products to a database (either set up in the .com or .net), but then I could pull the products out through both the .com and .net. But...it doesn't look like that is going to be possible with the hosting plans she has. Thanks for all your help...have given me some good reading material.

Thanks, you answered my question...though it wasn't what I wanted to hear. Let me ask you this...are there services out there that offer a mysql databases in this sort of situation...so that you can connect to them from numerous places?

Here's the situation. I have two websites that are basically mirrors of each other. One is a .com and the other .net and each site is hosted through a different hosting company. My plan was to set up a mysql database on the .net site and then connect to this database through both the .com and .net site. So I setup the database on the .net site and then uploaded files to the .com site. I went to the files I uploaded, where a connection to this database was required and it was unable to make the connection even though I know all the connection info was correct. Can hosting companies make it where you can't connect to the database from other hosting companies...is there anyways to override this. Any feedback would be appreciated. Thanks.

PHP 5 Objects, Patterns, and Practice by Matt Zandstra. I like this book.