[magnus]

Alphabetize Garage List


Actually, I take that back. Yes, you CAN alphabatize your listing very easily using LEFT JOIN.

In vbgarage.php:

FIND:

PHP Code:

        SELECT * FROM " . TABLE_PREFIX . "vbgarage_users ORDER BY userid ASC LIMIT $pos,$perpage 


REPLACE with:

PHP Code:

        SELECT vbgarage_users.*,user.username FROM vbgarage_users LEFT JOIN user ON vbgarage_users.userid = user.userid ORDER BY username ASC LIMIT $pos,$perpage 


Done!