moderate.php

[sabret00the]

it's in the left join :ermm:

[Andreas]

Nope. You make a join, but you don't select columns from the joined table
If you want username and userid you should do

PHP Code:

 $confessions=$DB_site->query("
            SELECT confessions.confessionid, confessions.text, confessions.userid, user.username
            FROM " . TABLE_PREFIX . "confessions AS confessions
            LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid = confessions.userid)
            WHERE visible=0

        while ($confession=$DB_site->fetch_array($confessions)) { 


[sabret00the]

ahhhh you're right such a stupid mistake

thank you so much, i'm so grateful for the help you've given me with this.