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's late and my brain
> is tired..

Read the MySQL manual, section  7.4.11 Date and Time Functions

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

PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to