[sql]$result_list = $DB_site->query("
SELECT vbgarage_users.*, vbgarage_images.*, user.username, user.usertitle
FROM " . TABLE_PREFIX . "vbgarage_users AS vbgarage_users, " . TABLE_PREFIX . "vbgarage_images AS vbgarage_images
LEFT JOIN " . TABLE_PREFIX . "user ON vbgarage_users.userid = user.userid
WHERE vbgarage_images.userid = $list[userid]
ORDER BY user.username ASC, vbgarage_images.imageid ASC
LIMIT $pos,$perpage
");[/sql]Does that work in your environment?
|