[flexcoders] Re: PHP Data Service

[Stephen]

Further to my previous post I have noticed a slight diffrence in the returned 
data from the service.

This object was returned by var_dump($o->getView_heatingByID(2));
and works.

object(stdClass)#4 (2) {
  ["heating_id"]=>
  int(2)
  ["heating_name"]=>
  string(12) "Radient Heat"
}

While this object was returned by var_dump($o->getView_heatingByName('Radient 
Heat')); 
and does not work?

object(stdClass)#3 (2) {
  ["heating_id"]=>
  int(2)
  ["heating_name"]=>
  string(12) "Radient Heat"
}

Whats going on here is my code...

public function getView_heatingByName($itemID) {
                
$stmt = mysqli_prepare($this->connection, "SELECT * FROM $this->tablename where 
heating_name=?");
$this->throwExceptionOnError();
                
mysqli_stmt_bind_param($stmt, 's', $itemID);            
$this->throwExceptionOnError();
                
mysqli_stmt_execute($stmt);
$this->throwExceptionOnError();
                
mysqli_stmt_bind_result($stmt, $row->heating_id, $row->heating_name);
                
if(mysqli_stmt_fetch($stmt)) {
return $row;
} else {
return null;
}

}