[criscokid]

Typical... I make a forum posting and then figure out what's wrong... vB wasn't happy because there wasn't a space between the = and the 'searchvalue'.

I've made some progress but I've still having a problem...

Here's my PHP code:

<?php
$selected = $_POST['selected']; 
require_once('global.php');
$dbuser="username";
$dbpass="password";
$dbname="database";  //the name of the database
$chandle = mysql_connect("localhost", $dbuser, $dbpass) 
    or die("Connection Failure to Database");
mysql_select_db($dbname, $chandle) or die ($dbname . " Database not found." . $dbuser);

$counter = 0;

    // Lets get the Recent Reviews
        $queryz = ("SELECT 
  rp_products.title,
  rp_reviews.username,
  rp_reviews.userid,
  rp_reviews.review,
  rp_reviews.cat,
  rp_reviews.product,
  rp_products.bigimage,
  rp_products.cat,
  rp_products.userid
FROM
 rp_reviews
 INNER JOIN rp_products ON (rp_reviews.product=rp_products.id)
WHERE
  (rp_reviews.review IS NOT NULL) AND 
  (rp_products.approved = 1) AND
  (rp_reviews.userid = {$vbulletin->GPC['userid']})
ORDER BY
  rp_reviews.`date` DESC LIMIT 5");

$result = mysql_query($queryz) or die('Query failed: ' . mysql_error());

// Printing results in HTML
echo "<div align=\"center\">\n";
echo "<table width=\"100%\">\n";

while ($row = mysql_fetch_array($result)) { 

   $title = $row['title']; 
   $review = $row['review']; 
   $username = $row['username'];
   $product = $row['product'];
   $bigimage = $row['bigimage'];
   $cat = $row['cat'];

$review = strip_bbcode($review, $stripquotes = false, $fast_and_dirty = false, $showlinks = false); 

// split the message at the first paragraph
$preview = preg_split('#(\r\n|\n|\r)#', $review, -1, PREG_SPLIT_NO_EMPTY);
$displaypreview = $preview[0];

echo "\t<tr align=\"center\" valign=\"top\">\n";
echo "\t\t<td width=\"20%\" valign=\"top\"><a href=\"http://domain.com/party/showproduct.php\?product={$product}\"><img src=\"http://domain.com/party/data/{$cat}/thumbs/{$bigimage}\" alt=\"{$title}\" height =\"66\"border=\"0\" ></a><br />
{$title}<br/><br/></td><td align=\"left\" valign=\"top\">{$displaypreview}<br/><br/><a href=\"http://domain.com/party/showproduct.php\?product={$product}\">Read the full review of {$title}.<br/><br/></td>\n";
echo "\t</tr>\n";

}

echo "</table>\n";
echo "</div>\n";

mysql_close($chandle);
?>

When I view the user profile of 'person with userID of 1959' the output is nothing. If I change
(rp_reviews.userid = {$vbulletin->GPC['userid']})
to
(rp_reviews.userid = '1959')
then the script works fine / as expected so I suspect I might be using the wrong variable in my query.