Inserting SQL in PHP Problem - please help

[Warlord]

Originally Posted by DragonBlade

Your $db variable ain't global. XP

Before that line, insert:

PHP Code:

global $db; 


---leave out the "query_first" bit, that's just a method of your object.

Not sure that this is your only error, but that's where you're having the trouble at the moment.

--------------- Added [DATE]1262191036[/DATE] at [TIME]1262191036[/TIME] ---------------

Basically, inside any function, if $db is not specifically declared as a global variable, it will only look at the variables LOCAL to the function.

Ok I've removed the code to globalise the $db from the top of the plugin and added it to the prepare_output function, while dropping the query_first part, so now it looks like this:

function prepare_output($id = '', $options = array())

global $db;

    {
        $this->block_data['longbox'] = $db("SELECT * FROM " . TABLE_PREFIX . "formresults WHERE userid = '$bbuserinfo[userid]' , AND title = 'Resume' ");
    }

Unfortunately it still seems to give me the same error:

Parse error: syntax error, unexpected T_GLOBAL, expecting ';' or '{' in /home/righscom/public_html/addons/projectfanboy/vb/member.php(463) : eval()'d code on line 247



EDIT: Oh wait, that's not the same error. To the interweb!