Inserting SQL in PHP Problem - please help

[Warlord]

Thanks for the help, unfortunately every time I get one thing done something else is wrong.

Now it's telling me that the function name must be a string (on line 245).

I researched that error code and found this...

Well, I found the problem. It seems that I had a pair of parens ()' around the index of an array element instead of brackets []'s. Hence it was looking at a variable as a function. I.e.
Wrong: $arName('myindex')
Right: $arName['myindex']

http://www.webdeveloper.com/forum/sh...ad.php?t=81233

I figured maybe a variable in the array I was calling was being looked at as if it were a function like above, so I looked through the code and changed the parenthesis() around "SELECT * FROM " . TABLE_PREFIX . "formresults WHERE userid = '$bbuserinfo[userid]' , AND title = 'Resume' " to brackets[] but then I got this error.

Fatal error: Cannot use object of type vB_Database as array in /home/righscom/public_html/addons/projectfanboy/vb/member.php(463) : eval()'d code on line 245

But now that I look at it, I think that the parenthesis were right because even though it's part of the variable $db, it's still a sql query, right?

I think it's saying that I can't use the variable $db and I have to use a string instead for that part?

Anyway, I changed it back to parenthesis() and now I'm back to:

Fatal error: Function name must be a string in /home/righscom/public_html/addons/projectfanboy/vb/member.php(463) : eval()'d code on line 245

I'll keep researching.

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

Ok, I was re-reading your post and I think I was misunderstanding something before and it helps me to talk it out on "paper" so to speak.

Arrays look similar to variables.
Arrays are basically variables that hold multiple other variables (aka an array of other variables).

So, $db("SELECT * FROM " . TABLE_PREFIX . "formresults WHERE userid = '$bbuserinfo[userid]' , AND title = 'Resume' ") is not a variable but actually an array that uses a SQL query to generate its results.

But this is also an array, right?

array(
        'class' => 'resume',
        'title' => 'Resume',
        'hook_location' => 'profile_left_last'
    )

I think I may be starting to see the light.... (I'll probably edit this 15 more times while I look at it and think. )

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

Hmmm, I also found this...

There's also another problem that will cause the same type of response (function must be a string) and that's inadvertently including a $ in front of a predefined/language defined function.

So I tried removing the $ from in front of the "predefined function" $db but that gave me a different error so I changed it back. Still looking!

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

Ok, to see if this would work (it didn't but I'm trying to think outside the box )

I globalised $db and defined $resume as the sql query earlier in the code and then I defined $this->block_data['resume'] as $resume so the code looked like this.

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

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

class vB_ProfileBlock_resume 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())
  {

    $this->block_data['resume'] = $resume;
  }
}

Like I said, it didn't work and I got the exact same error on a different line, but I get the feeling I may be on the right track?

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

Okay, here is the latest and greatest code for my plugin which seems to be working other than the fact that I don't think $bbuserinfo[userid] is parsing and so nothing shows up. But on a good note, I don't seem to be getting any errors anymore.

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

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

class vB_ProfileBlock_resume 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())
  {

    $this->block_data['resume'] = $resume;
  }
}

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

Well son of a mazza frazzer.... Just to test it out, I changed out $bbuserinfo[userid] for '162' (my userid) and nothing still showed up.

I really thought that would work....

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

Kind of at a point where I'm a bit stumped.

[Warlord]

Any ideas?

[Warlord]

I'm making headway!

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

class vB_ProfileBlock_resume 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;
	$results = $db->query_read("SELECT output FROM " . TABLE_PREFIX . "formresults WHERE userid = '$bbuserinfo[userid]' AND title = 'Resume' ");

    $this->block_data['resume'] = $results;
  }
}

That get's no errors in the header, adds the Resume Tab to the profile and data is displayed in the content portion of the tab. The data it's displaying is confusing the heck out of me, but it's still a great leap forward for me I think.

Resource id #73 (the number changes with each member) is being generated in the tab's content portion. Still looking into this.