changing order of a php echo

[5jays]

okay I've figured out to create a blog on my site but, the date is showing oldest first. How can I change the order to Newest firts?

I'm using a repeat region echoing info from a database.

Here is the code:

<?php $HTTP_POST_VARS[<?php echo $row_blog['BLOG_DATE']; ?>

any ideas?

[Newsgroup_User]

Add to your SQL for the recordset

ORDER BY UNIX_TIMESTAMP(BLOG_DATE) DESC

--
Gareth
http://www.phploginsuite.co.uk/
PHP Login Suite V2 - 34 Server Behaviors to build a complete Login system.

[Newsgroup_User]

5jays wrote:
> okay I've figured out to create a blog on my site but, the date is showing
> oldest first. How can I change the order to Newest firts?

In the recordset dialog box, sort by BLOG_DATE, and set the sort order
to Descending.

--
David Powers, Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/