[smallbeer]

I'm just starting out in php so this might be really simple.

I have this bit of php/SQL

$sql="INSERT into minddump(time,name,email,url,story) VALUES (now(),'$name','$email','$url','$story')";

Instead of giving $time the value of now(), how do I make sure it's GMT?

TIA

Jamie

[Luke Redpath]

ASP is my thing, but I would imagine there is a PHP equivalent - if I wanted to be certain my time was displayed in GMT, I'd explicitly set the Locale ID at the top of the page for the UK, overiding the server, but if you know your server ID is set to the UK you shouldn't need to do this:

<%@LANGUAGE="VBScript", LCID=2057%>

[smallbeer]

Whe I use now() the time is coming up as 5 hours behind so I guess the server is on the east coast of america.

I'll look into the php equivalent of your suggestion.

Cheers Luke.

Jamie

[Stickman]

This might be no help at all as I don't know php, but when I last used it I had to make changes to the date/time and figured it out with these pages:

http://www.php.net/manual/en/function.time.php

http://www.php.net/manual/en/function.date.php

Hope that helps you somehow

[smallbeer]

I found this which I think is the equivalent to Luke's suggestion.

setlocale(LC_TIME,"en_UK");

I think I've played around so much with it though that I've changed something I shouldn't have! Now the date and time are just coming up as 0000-00-00 00:00:00!

I'm gonna leave it for now and come back later. I'd end up clubbing the monitor if I don't! :smash:

[Sharif]

What exactly are you trying to do... I might have a solution for your dillema

[smallbeer]

I was trying to do it back in April but never found an answer so...

When now() is stored in the database it's the server time, not GMT. The server is in the US -5 hours behind the UK so I want to either store the time in the database as now() +5hours or display it as Time + 5hours. The former would be preferable.

[Sharif]

You can try the following code, just a matter of mixing functions:

adddate(now(),interval <number of hours> hour)

Just replace <number of hours> with whatever you want, in this case 5.

[smallbeer]

Cheers, I'll try it out next time I need it.