| johnn |
07-10-2005 06:18 AM |
Nevermind. I figured it out on my own, but I figured I'd go ahead and post the solution here as some other person had the same problem and no one answered them.
Quote:
if ($reps = $DB_site->query("SELECT reputation.reputation,reputation.whoadded,reputati on.reason,user.username
FROM " . vb3_ . "reputation AS reputation
LEFT JOIN " . vb3_ . "user AS user ON reputation.whoadded=user.userid
WHERE reputation.reputation!=0 AND postid='".$post['postid']."'"))
|
Use that, and where it has the 2 instances of "vb3_" put your own table prefix there, if you have one (which you likely do). You can find what your table prefix is, if you don't know it, in your "includes/config.php" file.
That should work. |
More Information