[PHP] time stamp screwing up

2003-01-06 Thread - \[ Paul Ferrie \] -
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.

Re: [PHP] time stamp screwing up

2003-01-06 Thread Stephan Seidt
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

Re: [PHP] time stamp screwing up

2003-01-06 Thread - \[ Paul Ferrie \] -
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 ] -

Re: [PHP] time stamp screwing up

2003-01-06 Thread Jason Wong
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 --- //

Re: [PHP] time stamp screwing up

2003-01-06 Thread - \[ Paul Ferrie \] -
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

Re: [PHP] time stamp screwing up

2003-01-06 Thread Stephan Seidt
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,

Re: [PHP] time stamp screwing up

2003-01-06 Thread Jason Wong
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)

Re: [PHP] time stamp screwing up

2003-01-06 Thread - \[ Paul Ferrie \] -
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,

Re: [PHP] time stamp screwing up

2003-01-06 Thread - Edwin
- [ 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]... __

Re: [PHP] time stamp screwing up

2003-01-06 Thread - \[ Paul Ferrie \] -
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

Fw: [PHP] time stamp screwing up

2003-01-06 Thread Rick Emery
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

Re: [PHP] time stamp screwing up

2003-01-06 Thread Justin French
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,