[Boofo]

Originally Posted by DWard

I'm working on it

DWard, I have fixed your file. You really had some things messed up in it, sorry to say. You CAN'T put table prefixes on userid variables. This:

PHP Code:

$attachment_data = $DB_site->query("SELECT * FROM ".TABLE_PREFIX."attachment LEFT JOIN ".TABLE_PREFIX."user ON (".TABLE_PREFIX."user.userid = ".TABLE_PREFIX."attachment.userid) ".$soundclips_filetypes." ORDER BY ".$sorttype." asc LIMIT " . ($minlimit-1) . ", $perpage");
} 


Should be this:

PHP Code:

$attachment_data = $DB_site->query("
SELECT * FROM ".TABLE_PREFIX."attachment AS attachment
LEFT JOIN ".TABLE_PREFIX."user AS user ON (user.userid = attachment.userid) ".$soundclips_filetypes."
ORDER BY ".$sorttype." ASC
LIMIT " . ($minlimit-1) . ", $perpage"); 


And also, anytime you query more than one table in a query, ALL tables have to have the table AS table to it when someone has a table prefix in their db.

Here is the updated file.