[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
    ");