> 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
Hi Nicos,
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
solut
4 matches
Mail list logo
