Re: [PHP] Time stamp and changing to a date.

2003-03-28 Thread Ryan Gibson
On 28/3/03 11:44 am, "Philip J. Newman" <[EMAIL PROTECTED]> wrote: > $mydate = "20030328231154"; > > $myPrintDate=date ("l dS of F Y h:i:s A",$mydate); > > echo "$myPrintDate"; > > Whats wrong -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/un

RE: [PHP] Time stamp and changing to a date.

2003-03-28 Thread Rich Gray
> $mydate = "20030328231154"; > > $myPrintDate=date ("l dS of F Y h:i:s A",$mydate); > > echo "$myPrintDate"; > > Whats wrong $mydate should be a unix style timestamp not a MMDDHHMMSS type date/time format... Check the functions time() and mktime() to help you generate unix timestamps. HTH R

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, '

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

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 \] -
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

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

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 - \[ 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

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 \] -
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 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 th

Re: [PHP] Time Stamp

2002-09-18 Thread 1LT John W. Holmes
MySQL syntax is MMDDHHMMSS or "-MM-DD HH:MM:SS" ---John Holmes... - Original Message - From: "Chuck Payne" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, September 18, 2002 11:25 AM Subject: [PHP] Time Stamp > Hi, > > I have a form that I am using to update a mysq