# ORDER BY date DESC?

**URL:** <https://forum.kirupa.com/t/order-by-date-desc/195769>\
**Category:** Uncategorized\
**Created:** [August 2, 2006, 11:50pm UTC](https://forum.kirupa.com/t/order-by-date-desc/195769 "2006-08-02T23:50:17Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Daimz](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/daimz/32/2383_2.png) [@Daimz](https://forum.kirupa.com/u/Daimz)\
**Post date:** [August 2, 2006, 11:50pm UTC](https://forum.kirupa.com/t/order-by-date-desc/195769/1 "2006-08-02T23:50:17Z")

</div>

I have made a db and it only has to colums: date and text. At the moment when I veiw the content the most recent date is at the bottom and the older entry is at the top I know it is because of this:

> ORDER BY date DESC  
> but I dont know how to change it I have had a look at a few tutorials on it but the dont seem to explain it very clearly. is it possible to use “ASC” or ascend in stead of “DESC” or what should I be using instead. thanx alot:kommie: