Re: time stamp screwing up
| From: | Jason Wong | Date: | Mon, 06 Jan 2003 16:58:00 +0000 |
| Subject: | Re: time stamp screwing up | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-130448@lists.php.net to get a copy of this message | ||
On Tuesday 07 January 2003 00:49, - \[ Paul Ferrie \] - wrote:
> So Jason what your saying is this
>
> $query = "INSERT INTO contacts (id, name, pass, email, dateAdded) VALUES
>
> > (NULL, '$name', '$pass', '$email', '$time')";
>
> Should be
>
> $query = "INSERT INTO contacts (id, name, pass, email, dateAdded) VALUES
>
> > (NULL, '$name', '$pass', '$email', NOW())";
Yes. That'll insert mysql's notion of the current time into dateAdded.
--
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
/*
While having never invented a sin, I'm trying to perfect several.
*/