Inserting SQL in PHP Problem - please help

[Warlord]

DragonBlade,

I appreciate the help, and as you've pointed out I do need to brush up on my PHP. Actually I've never taken any courses on PHP or anything, everything I have learned is for the most part through trial and error or trying to decipher other people's work. I didn't understand this latest error right away but I did figure out that it ran into an IF statement, I just can't figure out where.


Here is my member_block_resume template:

<div class="alt1 block_row">
	<ul class="list_no_decoration">
		$block_data[resume]
	</ul>
</div>

Here is my plugin:
Hook Location: member_build_blocks_start
Title: Resume
Execution Order: 5
Plugin PHP Code:

$blocklist = array_merge($blocklist, array(
	'longbox' => array(
		'class' => 'resume',
		'title' => 'Resume',
		'hook_location' => 'profile_left_last'
	)
));

class vB_ProfileBlock_Longbox extends vB_ProfileBlock
{
	var $template_name = 'memberinfo_block_resume';

	function confirm_empty_wrap()
	{
		return false;
	}

	function confirm_display()
	{
		return ($this->block_data['resume'] != '');
	}

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

    {
        global $db;

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

Originally Posted by DragonBlade

Heh. See, $db is a variable containing a Object, and query_first is a method of that Object. You are calling that Method with a string meant for MySQL, but you forgot to call the method. XP

I tried looking up what you're talking about, because pretty much that entire paragraph confused me.

I know what variables are. I know what queries are. I didn't know what methods were (according to PHP.net they are the same thing as functions). And I still haven't found a definition of an object (I've found plenty of references to them, but not it's actual definition.)

So if $db is a variable containing an object, is an object just what that variable represents? For instance if the variable $a = 1, would 1 be the object?

Also, if methods and functions are the same thing, that means that the method/function in this case would be query_first which is a way to query the database, right? This kind of confused me because I thought I was supposed to drop query_first part like shown above.

The sentence that really threw me for a loop was.

You are calling that Method with a string meant for MySQL, but you forgot to call the method.

I don't understand how I can call the method but forget to call the method. Is that a typo maybe, or am I just not understanding?