> 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,
> 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

Reply via email to