a bit of code in need of fixing

part of a hack im making:

PHP Code:

 //Drakks Warning Hack
$warnifield="field10" //make x the field for ur warning level
$warnlevel = $DB_site->query_first("SELECT $warnifield FROM userfield WHERE $userid=$bbuserinfo");
        if ($warnlevel >= "10") {
                $warnphraze="NEEDS BANNING";    //u may set the warn phraze for each one
        } elseif ($warnlevel >= "7") {
                $warnphraze="Very Bad";
        } elseif ($warnlevel >= "4") {
                $warnphraze="Thats Rough";
        } elseif ($warnlevel >= "1") {
                $warnphraze="Evil's Apprentice";
        } else {
                $warnphraze= "Goody Goody";
        }
        if ($warnfield >= "10") {
                $warning='<img src="{imagefolder}/warn1.jpg"> $warnphraze';
        } elseif ($warnlevel >= "7") {
                $warning='<img src="{imagefolder}/warn2.jpg"> $warnphraze';
        } elseif ($warnlevel >= "4") {
                $warning='<img src="{imagefolder}/warn3.gif"> $warnphraze';
        } elseif ($warnlevel >= "1") {
                $warning='<img src="{imagefolder}/warn4.gif"> $warnphraze';
        } else {
                $warning='<img src="{imagefolder}/warn5.gif"> $warnphraze';
        }
//End Warning hack 


Theres also an error with the query,,, but... how can i get $warning too =<img src="{imagefolder}/warn5.gif"> and so on?

i know that Wont work.. how can i change it too make it work

[E]

u forgot to close the statement
$warnlevel = $DB_site->query_first("SELECT $warnifield FROM userfield WHERE userid='$variable1223');

=

$warnlevel = $DB_site->query_first("SELECT $warnifield FROM userfield WHERE userid='$variable1223'");

Anyways... I finally got rid of that error.. so thanks for all ur help i really appreciate it... now i get this errror instead

Fatal error: Call to a member function on a non-object in /home/fiendwor/public_html/forum/admin/functions.php on line 215

215:
$warnlevel = $DB_site->query_first("SELECT $warnifield FROM userfield WHERE userid='$uservar'");

$uservar is instead of variable1223... so i did change it dont worry

[Logician]

Originally posted by E

$warnlevel = $DB_site->query_first("SELECT $warnifield FROM userfield WHERE userid='$uservar'");

Try

$warnlevel = $DB_site->query("SELECT $warnifield FROM userfield WHERE userid='$uservar'");

[E]

gives the same warning.. damn this is getting nowhere lol... where Firefly with his one post fixes... lol

[E]

dammit.. i see problems being fixed in a day.. this has been ages.. there must be some way to do this

[mr e]

What happens if you do this?

PHP Code:

$warnlevel = $DB_site->query_first("SELECT $warnifield,userid FROM userfield WHERE userid='$uservar'"); 


[E]

its not that... the WHERE userid bit.......... The
$uservar = $bbuserinfo['userid']

Dammit it dont recognize that [better wash my mouth][better wash my mouth][better wash my mouth][better wash my mouth]

[E]

i said bit not [better wash my mouth][better wash my mouth][better wash my mouth][better wash my mouth][better wash my mouth]

[mr e]

Don't you have to SELECT the userid also? Post what you currently have up to this point.