Adding Query into showthread.php

[miz]

huh ?
i got you all worng
are you tring to make like vote systen ?
that users will vote who is the winner of the game ?

if you want to use the query you provided (NOT RECOMANED)
here is the syntax :

PHP Code:

if ($thread[threadid] == 1)
{
$gettitle = $DB_site->query("SELECT * from ".TABLE_PREFIX."USER where USERNAME='$thread[threadpostername]'");
while ($postloser = $DB_site->fetch_array($gettitle)
{
// do ++++ here
this query will get all users  
}
} 


or if you want to get only 1 user
user

PHP Code:

 $gettitle = $DB_site->query_first("SELECT * from ".TABLE_PREFIX."USER where USERNAME='$thread[threadpostername]'"); 


offcurse everything depends on what you want to do
also its might be able that $thread values will be $threadinfo

test on your own risk.