Hi
ive managed to get this working no problem on 3.0.1
however i just got the error
Invalid SQL:
SELECT vbgarage_users.*,user.username FROM vbgarage_users LEFT JOIN user ON vbgarage_users.userid = user.userid ORDER BY username ASC LIMIT 0,25
mysql error: Table databasename.vbgarage_users' doesn't exist
mysql error number: 1146
i did have it working just before i tried to view the list?
my table is vb3_vbgarage_users not vbgarage_users
if i add in my table prefix it tells me
Code:
the table vbulletin.user' doesn't exist
Code:
$result_list = $DB_site->query("
SELECT vbgarage_users.*,user.username FROM vbgarage_users LEFT JOIN user ON vbgarage_users.userid = user.userid ORDER BY username ASC LIMIT $pos,$perpage
");
anyone help me with this???