I have the following query:
$query1 = "INSERT INTO whoisonline VALUES (NULL,'$memberid', FROM_UNIXTIME('$lastlogin'), '$loggedfromip')";
This query works like a charm, however, I have the following problem.
The time inserted is local time on server which beloing to time zone 'America/Denver'
I would like the time inserted to be 'Europe/Athens' time zone. I try with:
without any success however. Any help will be deeply appreciated.
It won't, since I am on shared hosting. I have no permissions to do any of the things mentioned on the page. Any other way? Any idea how to rewrite the query eventually?
instead of inserting FROM_UNIXTIME($lastlogin), insert FROM_UNIXTIME($lastlogin + 8*60*60)