> 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?? SELECT UNIX_TIMESTAMP(your_timestamp_column) AS alias FROM your_table ... SELECT DATE_FORMAT(column,'<format>'), column2, column3, etc FROM yourtable ... You have to name the columns and not use * in your query. You'll also want to read up on the AS alias, if you don't know what that is. ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php