From: [EMAIL PROTECTED] Operating system: windows 98 PHP version: 4.0.4pl1 PHP Bug Type: Strings related Bug description: Inconsistency in the implementation of here-docs Parse error: parse error in units.inc on line 11 When I try to instantiate this class I get the above error. The same query strings work fine when I use them in a procedural context <?php class UnitReport { var $db; // This is the DB connection string var $result; /*This holds the returned recordset from the query*/ var $sqlQueryByLocation1 = <<<QUERYBYLOCATION1 select money_sorted.dialup_user, unit.address1, SUM(money_sorted.money_inserted) from money_sorted INNER JOIN unit ON (unit.dialup_user = money_sorted.dialup_user) WHERE unit.status ="Active" GROUP BY unit.address1 QUERYBYLOCATION1; var $sqlQueryByLocation2 = <<<QUERYBYLOCATION2 select money_sorted.dialup_user, unit.address2, SUM(money_sorted.money_inserted) from money_sorted INNER JOIN unit ON (unit.dialup_user = money_sorted.dialup_user) WHERE unit.status ="Active" GROUP BY unit.address2 QUERYBYLOCATION2; var $sqlQueryByLocation3 = <<<QUERYBYLOCATION3 select money_sorted.dialup_user, unit.address3, SUM(money_sorted.money_inserted) from money_sorted INNER JOIN unit ON (unit.dialup_user = money_sorted.dialup_user) WHERE unit.status ="Active" GROUP BY unit.address3 QUERYBYLOCATION3; var $sqlQueryByLocation4 = <<<QUERYBYLOCATION4 select money_sorted.dialup_user, unit.address4, SUM(money_sorted.money_inserted) from money_sorted INNER JOIN unit ON (unit.dialup_user = money_sorted.dialup_user) WHERE unit.status ="Active" GROUP BY unit.address4 QUERYBYLOCATION4; function connectDb($host,$database,$user,$pass) { $db = mysql_connect($host,$user,$pass); mysql_select_db($database,$db); } //Get revenue by location address1 /*function rev_by_location1() { $this->$result = mysql_query($this->$sqlQueryByLocation1,$this->$db); } //Get revenue by location address2 function rev_by_location2($day_start,$month_start,$year_start,$day_end,$month_end,$year_end) { $this->$result = mysql_query($sqlQuery,$this->$db); } //Get revenue by location address3 function rev_by_location3($day_start,$month_start,$year_start,$day_end,$month_end,$year_end) { $this->$result = mysql_query($sqlQuery,$this->$db); } //Get revenue by location address4 function rev_by_location4($day_start,$month_start,$year_start,$day_end,$month_end,$year_end) { $this->$result = mysql_query($sqlQuery,$this->$db); } //Get revenue by present for all units function rev_to_present() { $this->$result = mysql_query($sqlQuery,$this->$db); } // function last_opened($spreadsheet) { $this->$result = mysql_query($sqlQuery,$this->$db); } function rev_two_dates($spreadsheet) { $this->$result = mysql_query($sqlQuery,$this->$db); } function display() { }*/ } ?> -- Edit Bug report at: http://bugs.php.net/?id=9262&edit=1 -- PHP Development Mailing List <http://www.php.net/> To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]