> Hi John,
>
> How do u use UNIX_TIMESTAMP or DATE_FORMAT in your query. My query now
> looks like this:
>
> "SELECT * FROM guestbook2002 ORDER BY entryID DESC LIMIT $entry,
$show";
>
> Can u help me;-) Thanks for your time
Did you read the Date and Time Functions chapter of the MySQL manual??
al Message-
From: John W. Holmes [mailto:[EMAIL PROTECTED]]
Sent: Sunday, October 06, 2002 3:31 PM
To: 'Davy Obdam'; [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: [PHP-WIN] RE: [PHP] Re: Using date() function
> Using $entry_date = date('l, d F Y H:i:s',$s
> Using $entry_date = date('l, d F Y H:i:s',$sql['date']); now gives me
> back Tuesday, 19 January 2038 04:14:07 with ever entry. $sql['date']
is
> a TIMESTAMP and looks like this 20021006141256 in the datebase. It
> should give me Sunday, 06 October 2002 14:12:56..? Wierd eh? Do u know
a
> soluti
Hello,
Why not just do it in your sql query?
If you're using MySQL perhaps this page would be helpful:
http://www.mysql.com/doc/en/Date_and_time_functions.html
Just an idea...
- E
On Sunday, October 6, 2002 10:01 PM
Davy Obdam wrote:
> Hi people
>
> I have a guestbook, and i need to conv
12:56..? Wierd eh? Do u know a
solution?
Best regards,
Davy Obdam,
mailto:[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Sunday, October 06, 2002 1:59 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP] Re: Using date() function
Firs
First you should use :
$entry_date = date('l, d F Y H:i:s',$sql['date']);
And $sql['date'] must be a TIMESTAMP.
--
Nicos - CHAILLAN Nicolas
[EMAIL PROTECTED]
www.WorldAKT.com - Hébergement de sites Internet
"Davy Obdam" <[EMAIL PROTECTED]> a écrit dans le message de news:
001601c26d2c$e5391ff
6 matches
Mail list logo
