Hi,

i have the problem about the "date time" setting

this is the php code that i used to insert data to sql database
$Fname = $_POST["Fname"];
$Lname = $_POST["Lname"];
$gender = $_POST["gender"];
$sql="INSERT INTO $tbl_name(firstname, lastname, gender, datetime)
VALUES('$Fname', '$Lname','$gender', NOW() )";


when i submit data to database, the datetime data will be auto insert into datetime field. However, the date time is not same with my country time.

eg, data insert to database is (2010-12-25 15:21:36) , but it should be (2010-12-25 23:22:36)

for you information, im from Malaysia. Appreciate your help ....
thanks...

The time will be the server time, you will have to make allowances for that when you are displaying or reading the data.

Unless you lease a server in your own time zone

thanks for your info...

is it can do any coding to make the datetime value that based on Personal Computer time...?

Try this. http://php.net/manual/en/datetime.settimezone.php
I think is what you want

http://www.webmaster-talk.com/javasc...de-script.html

To set the timezone in a php script, simply use the inbuilt function date_default_timezone_set().

http://php.net/manual/en/function.da...mezone-set.php

simply use the inbuilt function date_default_timezone_set(). the Time zone will be selected............