Messages in Home

Worker Joined: Jun 29, 2003 Posts: 146 Location: Oklahoma

Is there a way to make it when you post new messages in home...it post the last one on top instaed of the bottom? Like a reverse order? When I post new stuff...it puts it at the bottom....and I need it at the top

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

Try this. In mainfile.php, locate the function message_box(). On or about line 335 find this code

Code:

    $sql = "SELECT mid, title, content, date, expire, view FROM ".$prefix."_message WHERE active='1' $querylang";

and change it to

Code:

    $sql = "SELECT mid, title, content, date, expire, view FROM ".$prefix."_message WHERE active='1' $querylang order by date desc";

Posted: Mon Sep 29, 2003 8:58 pm

That worked man thanks a million...you really know your stuff!