class isue

[viveleroi0]

class DB_Query{
var $My_Query;
var $Content;
$result=mysql_query("$My_Query");
$num=mysql_num_rows($result);
if($num=="0"){echo"$header$NoResults$footer";}else{echo"$header$Content$footer";}
}

$NewDBConnection=&New DB_Query;
$NewDBConnection->My_Query="SELECT * FROM Products WHERE ID=\"$SearchID\"";
$NewDBConnection->Content="Temp";

when this is run from a form with a field of SearchID, I get this:

Parse error: parse error, expecting T_OLD_FUNCTION' orT_FUNCTION' or T_VAR' or'}'' in /home/www/jazbot/php/Jazz/PM/kernel.php on line 128

where line 128 is
$result=mysql_query("$My_Query");

from above. What the heck does that error mean?

[crosbystillsnas]

class DB_Query{ 

var $Content; 

function DB_Query($My_Query){

 $result=mysql_query("$My_Query"); 
 $num=mysql_num_rows($result); 
 // $header, $NoResults, $footer are undefined
 //if($num=="0"){echo"$header$NoResults$footer";}
 // $header, $content, $footer will be undefined
 //else {echo"$header$Content$footer";}
 if($num>0){
  // get results
  $i = 0;
  while($list = mysql_fetch_row($result)){
  $this->Content[$i] = $list;
  $i++;
  }
 } else{
  echo "THERE WERE NO RESULTS.";
 }

}

} 

called by:

$NewDBConnection = new DB_Query("SELECT * FROM Products WHERE ID=\"$SearchID\""); 

or do you mean something totally different?