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.
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
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 ] -
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 ---
//
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
Jason
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,
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)
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 (id, name,
- [ 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]...
__
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 be somewhere
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: Re: [PHP] time stamp screwing up
Well i am still
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,
12 matches
Mail list logo