The Edge Homepage

# Calendar problem **URL:** \ **Category:** Uncategorized\ **Created:** [August 9, 2004, 12:34am UTC](https://forum.kirupa.com/t/calendar-problem/118760 "2004-08-09T00:34:56Z")\ **Posts on this page:** 3\ **Page:** 1

**Author:** ![SlowRoasted](https://avatars.discourse-cdn.com/v4/letter/s/a698b9/32.png) [@SlowRoasted](https://forum.kirupa.com/u/SlowRoasted)\ **Post date:** [August 9, 2004, 12:34am UTC](https://forum.kirupa.com/t/calendar-problem/118760/1 "2004-08-09T00:34:56Z")

ok this is a news calendar. All is going well so far with the code but i want to reverse the order that the records are displayed. So right now the newest items are on bottom and the older items are on top, i want to reverse that. Can someone help plz ```php The Edge Homepage 0){ while($row = mysql_fetch_array($result, MYSQL_NUM)){ echo""; } } else { echo'The calendar is experiencing technical difficulties. We apologize for the inconvenience.'; } echo'

$row[0]

$row[1]

'; mysql_free_result($result); mysql_close(); ?> ``` ---

**Author:** ![Hans\_Kilian](https://avatars.discourse-cdn.com/v4/letter/h/838e76/32.png) [@Hans\_Kilian](https://forum.kirupa.com/u/Hans_Kilian)\ **Post date:** [August 9, 2004, 6:21am UTC](https://forum.kirupa.com/t/calendar-problem/118760/2 "2004-08-09T06:21:55Z")

Change your SQL from $query = “SELECT date, subject FROM Calendar”; to $query = “SELECT date, subject FROM Calendar ORDER BY date DESC”; ---

**Author:** ![SlowRoasted](https://avatars.discourse-cdn.com/v4/letter/s/a698b9/32.png) [@SlowRoasted](https://forum.kirupa.com/u/SlowRoasted)\ **Post date:** [August 9, 2004, 2:16pm UTC](https://forum.kirupa.com/t/calendar-problem/118760/3 "2004-08-09T14:16:19Z")

thanks man, ill try that;) edit: sweet it works thanks:)