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?

PHP Code:

    $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.reputationlevelid)") . "
        WHERE usernote.userid = $userinfo[userid]
        ORDER BY usernote.dateline LIMIT " . ($limitlower - 1) . ", $perpage
    "); 


[Boofo]

Try changing this:

PHP Code:

ORDER BY usernote.dateline 


to:

PHP Code:

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.