Hi Pete, I did sort one of my dbs by "year" when I was re-organizing, but luckily I'd saved the sql dump. Why I sorted it was because it was originally a flat file, which I'd converted. It didn't have timestamps, just the dates.
As you can guess, I'm still learning to use mysql databases *grin*. Thanks for the advice. Just got MAX() working after about 4hrs. I'd missed out the "AS logged" (It was nattering me. Don't need a haircut now!) MAX(logged) to me, looks the more logical way of doing it. Any idea which would be the most efficient? SELECT UNIX_TIMESTAMP(MAX(logged)) AS logged FROM forum or SELECT UNIX_TIMESTAMP(logged) AS logged FROM forum ORDER BY logged DESC LIMIT Regards, Bob. ----- Original Message ----- From: "Pete" <[EMAIL PROTECTED]> > Then, you never 'sort' (your word) a MySQL database. You make it appear > in a different sequence of records (i.e., 'appear sorted') by using > indexes. Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
