Re: Date is not being pulled from MYSQL database, instead current date is displayed!!!

Message-ID: <1143154489.799918.244230@e56g2000cwe.googlegroups.com> from
ameshkin contained the following:

>Here is a reply in another forum after someone stated taht it was
>strange taht still did not work.
>
>The page is at http://www.mytuneslive.com/ameshkin69/
>
>OK, what I did is just output the raw $row_comment['timestamp']
>
>This gives u the value in the database in a unix timestamp. Below is
>the mysql query....and underneath that is the entire table in case
>something else is causing trouble.

Umm..that's not a UNIX timestamp. A UNIX timestamp is the number of
seconds since Jan 1st 1970. Yours starts with 2006, which should be a
huge clue..

You'll have to convert it to a UNIX timestamp or get the query to
format it.

To convert do something like
SELECT comments.owner, comments.UNIX_TIMESTAMP(timestamp) AS
unix_timestamp ,comments.comment,comments.author, comments.cmtpic,
comments.autoFROM comments ...

-- 
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/