Hello mysql,
I do this:
$query = "INSERT INTO news(ID, author, title, text, date) VALUES(NULL,
'".$_SESSION["ulogged"]."', '".$title."', '".$text."', UNIX_TIMESTAMP(NOW()))";
$result = mysql_query($query, $connection) or die("problem with query");
I get this:
mysql> select * from news where id='1';
+----+--------+----------+----------------------------+----------------+
| ID | author | title | text | date |
+----+--------+----------+----------------------------+----------------+
| 1 | myuser | news | blah blah blah | 20030323225645 |
+----+--------+----------+----------------------------+----------------+
1 row in set (0.01 sec)
Look at the time! It's set ... strange :) 2003 03 23 22 56 45 .. it's
not neither now() format, neither unix_timestamp() format.
mysql> select now(), unix_timestamp(now());
+---------------------+-----------------------+
| now() | unix_timestamp(now()) |
+---------------------+-----------------------+
| 2003-03-23 23:07:30 | 1048453650 |
+---------------------+-----------------------+
1 row in set (0.01 sec)
It's okay. So, why in the query from a php form the unix time date is
saved wrong? Any ideas and suggestions?
--
best wishes,
Strahil Minev a.k.a. DLHelper,
BuFu TeaM mailto:[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
