Inserting SQL in PHP Problem - please help

[DragonBlade]

Hmmm... Let me see what the best way to define it is...


You probably know what Arrays are. Like $bbuserinfo--it's an array that holds multiple variables inside of it. It can even hold other Arrays and even Objects. $bbuserinfo has several "keys" that hold values: $bbuserinfo['userid'] holds the userid, $bbuserinfo['username'] the name, and so on.


Well, think of an Object as an Array that can hold it's own special functions (called "Methods").

$db is a Database Object that holds functions for communicating with the database.
$db->query_first() is a method that returns one row from the database.
$db->query_read() is a method that can return multiple rows.
$db->query_write() allows you to write to the database.

Objects can also hold regular variables;
$vbulletin is an Object, and
$vbulletin->userinfo is an array that holds the userinfo of the currently logged in user (like $bbuserinfo).
$vbulletin->userinfo['userid'] holds the UserID of the currently-logged-in-user.

Objects are really more of an advanced PHP topic that you really will only understand with experience, but they really make life a lot easier.




Okay, now to get to what it is you wanted, heh.

Add an end-curly-brace to the end of your code.

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' ");
  }
} 


I don't really know what a great code editor is for Windows, which you're probably using, but I used to use ConTEXT (google "context text editor") and liked it. I use Kate on my Linux and I adore it, but I don't think they have it for Windows, but if you arrange your code nicely you can see that you were just missing an end bracket. XP



I'd like to help you out more on unerstanding Object, but I just can't think of a decent way to explain them without knowing just how far you've delved into PHP. XD But you seem very new to PHP, so really understanding Object might be a little beyond you at the moment. Still, if you want to take a looksee...

http://php.net/manual/en/language.oop5.php

Warning--you will NOT understand everything in one sitting; it's a very big topic to grasp.