Addressed to: "Timothy Wright" <[EMAIL PROTECTED]>
<[EMAIL PROTECTED]>
> I need to convert the input to a valid timestamp first.
>
> Any ideas?? Am I missing something really obvious...it's late and my brain
> is tired..
Read the MySQL manual, section 7.4.11 Date and Time Functions
http://www.mysql.com/doc/D/a/Date_and_time_functions.html
You can convert a MySQL date to a Unix Timestamp, with UNIX_TIMESTAMP,
but the real answer to your problem is:
Just because MySQL returns it, that doesn't mean you have to print it.
It does not cost that much to return a duplicate date on every record.
You are going to be returning a unix timestamp on every record, and the
fact of the matter that converting the internal date format to a uniz
timestamp is as much a date formatting operation as DATE_FORMAT().
So, go ahead and use MySQL to format the value, and only print it the
first time it appears.
Rick Widmer
Internet Marketing Specialists
http://www.developersdesk.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
