Skip to main content
Participant
March 7, 2007
Question

changing order of a php echo

  • March 7, 2007
  • 2 replies
  • 312 views
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?
This topic has been closed for replies.

2 replies

Inspiring
March 7, 2007
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/
Inspiring
March 7, 2007
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.