FRIHOST • FORUMS • FAQ • TOS • BLOGS • DIRECTORY

You are invited to Log in or Register a Frihost Account!

inverting order

Frihost Forum Index -> Scripting -> Php and MySQL

Heya. Does anyone know how to invert this (to make the order reverse, so that it shows in decending order, not ascending):

Code:

$sql = "SELECT * FROM messaging WHERE to_user='$curruser2' order by msg_id";

ChrisCh wrote:

Heya. Does anyone know how to invert this (to make the order reverse, so that it shows in decending order, not ascending):

Code:

$sql = "SELECT * FROM messaging WHERE to_user='$curruser2' order by msg_id";

Use this

Code:

$sql = "SELECT * FROM messaging WHERE to_user='$curruser2' order by msg_id desc";

Thanks for that. 'Tis working beautifully Smile

Smile

Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2007 Frihost, forums powered by phpBB.