[Shepski]

i had a look at the join statement earlier but could get it to work. this is what i ended up with:

$adult=$DB_site->query("SELECT users.userid FROM users
LEFT JOIN adult ON adult.uid = users.userid, adult.extrapostbit as extrabit WHERE adult.uid = users.userid
");

but i just keep getting mysql errors and alot of annoyed users as they keep trying to post as I make the changes and mess things up!

how close am I? the postbitextra is the bit i want to pull into the postbit and display for each user in the thread view which I presume will end up being something like $adult[extrabit] in the postbit template in-order to display it.