setting mysql timezone

[dila125]

I'm in the UK but my server is in the US, so I'm trying to change the mysql timezone on a per connection basis.

I'm testing this with the following code, but it doesn't work. Can someone see what the problem is:

$db_username='xxx';
$db_password='xxx';
$result = mysql_pconnect('localhost', $db_username, $db_password); 
mysql_query('SET @@session.time_zone:=Europe/London');
$result = mysql_fetch_array(mysql_query("SELECT @@session.time_zone"));
echo $result['@@session.time_zone'];

The echo I get back is always "SYSTEM"!!

[obsidian]

this may be helpful

MySQL Manual wrote:

Per-connection time zones. Each client that connects has its own time zone setting, given by the session time_zone variable. Initially, the session variable takes its value from the global time_zone variable, but the client can change its own time zone with this statement:

mysql> SET time_zone = timezone;

with this in mind, you may be able to simply do something like this:

SET time_zone = 'Europe/London';
SELECT @@session.time_zone;

[dila125]

Thanks, i've tried that but unfortunatly the outcome is the same. Have also tried using the root username and password but that didn't help either.