Reversing Order Of Usernotes?

[colicab-d]

This may be a dumb and obvious question, but how would I go about reversing the order of usernotes so that the newest one is listed first?

Ive tried looking at the code in usernotes.php and have managed to get it down to this code which is determining the order...

How woul I change this to reflect what Im trying to do?

$notes = $DB_site->query("
SELECT usernote.*, usernote.username as postusername, user.*, userfield.*,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
IF(posterid=0, 0, user.userid) AS userid
" . iif($vboptions['avatarenabled'],",avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline") . "
" . iif($vboptions['reputationenable'], ",level") . "
FROM " . TABLE_PREFIX . "usernote AS usernote
LEFT JOIN " . TABLE_PREFIX . "user AS user ON(usernote.posterid=user.userid)
LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield ON(userfield.userid=user.userid)
LEFT JOIN " . TABLE_PREFIX . "usergroup AS usergroup ON(user.usergroupid=usergroup.usergroupid)
" . iif($vboptions['avatarenabled'],"LEFT JOIN " . TABLE_PREFIX . "avatar AS avatar ON(avatar.avatarid=user.avatarid) LEFT JOIN " . TABLE_PREFIX . "customavatar AS customavatar ON(customavatar.userid=user.userid)") .
iif($vboptions['reputationenable'], " LEFT JOIN " . TABLE_PREFIX . "reputationlevel AS reputationlevel ON(user.reputationlevelid=reputationlevel.reputati onlevelid)") . "
WHERE usernote.userid = $userinfo[userid]
ORDER BY usernote.dateline LIMIT " . ($limitlower - 1) . ", $perpage
");

[Boofo]

Try changing this:

ORDER BY usernote.dateline

to:

ORDER BY usernote.dateline ASC

[colicab-d]

will do mate thnx for the speedy reply :)

[noonespecial]

ORDER BY usernote.dateline DESC

will show oldest first.

/works in vb 3.5.1 as well
// imo should be defaulted this way.