[RESOLVED] Storing the correct time

[Jon12345]

I have some code that logs clicks on a site. It stores the curtime(). But which time is it? The time on the server? If so, how do I alter my code so I store the GMT time instead of whatever time zone (Pacific?) is on the server?

if (mysql_num_rows($ip_query) < 1) {
	mysql_query("insert into logfile(Category, SubCategory, Product, Keyword, Position, Date, Time, Testcode, IPaddress, Nixxieurl1) values('$category', '$productname', '$filter', '$keyword', '$key', curdate(), curtime(), '$test', '$ip', '$url')"); 
}

Thanks,

Jon

[toplay]

You should always save dates/times based on the server. Then when it comes to displaying the date/time, you adjust it before displaying it. See my other post:

http://www.phpbuilder.com/board/showpost.php?p=10648630&postcount=3

🙂

[Jon12345]

Good point. Thanks!