A MySQL timestamp is different to a MySQL timestamp.
$time = time(); will produce a unix timestamp
what you want is
$time = date('Y-m-d');
to give a value in the format -MM-DD
I think you can also use NOW():
$query = "INSERT INTO contacts (id, name, pass, email, dateAdded) VALUES
(NULL, '
show us your database table structure (the whole thing). the NOW() will always work
with a "date"
or "timestamp" field
- Original Message -
From: "- [ Paul Ferrie ] -" <[EMAIL PROTECTED]>
To: <>
Sent: Monday, January 06, 2003 11:28 AM
Subject:
Well i am still getting all the zero's
: ( : (
"- Edwin" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> "- [ Paul Ferrie ] -" <[EMAIL PROTECTED]> wrote:
> > So
> >
> > Is NOW() a mysql function?
>
> Well, you can check for yourself ;)
>
> It should
"- [ Paul Ferrie ] -" <[EMAIL PROTECTED]> wrote:
> So
>
> Is NOW() a mysql function?
Well, you can check for yourself ;)
It should be somewhere around here:
http://www.mysql.com/doc/en/Date_and_time_functions.html
- E
...[snip]...
__
So
Is NOW() a mysql function?
"Stephan Seidt" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> yep i guess that, so NOW() is a mysql function.
>
> - [ Paul Ferrie ] - wrote:
> > So Jason what your saying is this
> >
> > $query = "INSERT INTO contacts
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
yep i guess that, so NOW() is a mysql function.
- [ 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
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())";
??
cheers
On Tuesday 07 January 2003 00:19, - \[ Paul Ferrie \] - wrote:
> hey guys could someone help me
> I have created a user login register system in flash with PHP and Mysql.
> Everthing Now works fine aprt from the time stamp of when the user
> registered.
>
> Code ---
nope it still comes up with all the zero's
:(
"Stephan Seidt" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> What sort of mysql field type did you use for dateAdded ?
> You need UNIX_TIMESTAMP (or sth like that) for unix timestamp format.
>
> - [ Paul Ferrie ]
What sort of mysql field type did you use for dateAdded ?
You need UNIX_TIMESTAMP (or sth like that) for unix timestamp format.
- [ Paul Ferrie ] - wrote:
hey guys could someone help me
I have created a user login register system in flash with PHP and Mysql.
Everthing Now works fine aprt from th
hey guys could someone help me
I have created a user login register system in flash with PHP and Mysql.
Everthing Now works fine aprt from the time stamp of when the user
registered.
Code ---
// Get current date & time
$time = time();
// Connects to the Database.
$
12 matches
Mail list logo
