I've got a MySQL question for you.
Is the php value <?echo time();?> suitable for a MySQL timestamp field?
The reason I ask is because I'm getting an odd result in my web content
publishing site.
I'm grabbing form data from a query string and inserting it into MySQL.
(NewsDate is a MySQL timestamp field)
$query = "INSERT INTO News(Headline, Story, Status, Author,
NewsDate) VALUES('" . $_GET['Headline'] . "', '" . $_GET['Story'] . "', '" .
$_GET['Status'] . "', '" . $_GET['Author'] . "', '" . time() . "')";
This query works fine, but when I view the information on my news page the
date returned ($row->NewsDate) is:
00000000000000
Which formatted with this function <?echo date("h:i d M Y",
$row->NewsDate);?> returns:
11:00 01 Jan 1970
If I leave the time() function out of my insert statement then the returned
value is:
20030320084636 or (02:14 19 Jan 2038)
Does anyone know what is going on here?
Any help, much appreciated.
Rob
(I'm making the tranistion between ASP & Access to PHP and MySQL and am
having a tough time with this GUI-less database.)
*************************************************************
This mail, including any attached files may contain
confidential and privileged information for the sole
use of the intended recipient(s). Any review, use,
distribution or disclosure by others is strictly prohibited.
If you are not the intended receipient (or authorised to
receive information for the recipient), please contact
the sender by reply e-mail and delete all copies of
this message.
*************************************************************
--
SLUG - Sydney Linux User's Group - http://slug.org.au/
More Info: http://lists.slug.org.au/listinfo/slug
