🚀 go-pugleaf

Zapytanie SQL z poziomu PHP zwraca mi co innego niż to samo zapytanie z poziomu klienta mysql. Proszę zwrócić uwagę na wartość kolumny use_rooms ('-' z mysql oraz '' z PHP). Poniżej wybrałem jeden wiersz z wyników.

mysql> SELECT estate_type_id, use_region, use_town, use_district, use_address, use_floor_no, use_floors, use_area, use_rooms, use_offices, use_year_built, use_ownership, use_standard, use_house, use_buildings, use_garrage, use_parking, use_kitchen, use_balcony, use_gas, use_current, use_sewerage, use_furniture_type, use_equipment, use_guard, use_pictures, use_remarks FROM estate_types_visibility INNER JOIN estate_types USING(estate_type_id) ORDER BY estate_type_name ASC;
+----------------+------------+----------+--------------+-------------+--------------+------------+----------+-----------+-------------+----------------+---------------+--------------+-----------+---------------+-------------+-------------+-------------+-------------+---------+-------------+--------------+--------------------+---------------+-----------+--------------+-------------+
| estate_type_id | use_region | use_town | use_district | use_address | use_floor_no | use_floors | use_area | use_rooms | use_offices | use_year_built | use_ownership | use_standard | use_house | use_buildings | use_garrage | use_parking | use_kitchen | use_balcony | use_gas | use_current | use_sewerage | use_furniture_type | use_equipment | use_guard | use_pictures | use_remarks |
+----------------+------------+----------+--------------+-------------+--------------+------------+----------+-----------+-------------+----------------+---------------+--------------+-----------+---------------+-------------+-------------+-------------+-------------+---------+-------------+--------------+--------------------+---------------+-----------+--------------+-------------+
| DZI            | +          | +        | +            | +           | -            | -          | +        | -         | -           | +              | +             | +            | +         | +             | 0           | +           | +           | -           | +       | +           | +            | -                  | +             | +         | +            | +           |
+----------------+------------+----------+--------------+-------------+--------------+------------+----------+-----------+-------------+----------------+---------------+--------------+-----------+---------------+-------------+-------------+-------------+-------------+---------+-------------+--------------+--------------------+---------------+-----------+--------------+-------------+


public function getEstateTypesVisibility() {
    $sql = 'SELECT estate_type_id, use_region, use_town, use_district, use_address, use_floor_no, use_floors, use_area, use_rooms, use_offices, use_year_built, use_ownership, use_standard, use_house, use_buildings, use_garrage, use_parking, use_kitchen, use_balcony, use_gas, use_current, use_sewerage, use_furniture_type, use_equipment, use_guard, use_pictures, use_remarks ' .
           'FROM estate_types_visibility INNER JOIN estate_types USING(estate_type_id) ' .
           'ORDER BY estate_type_name ASC';
var_dump($sql);
$rec = $this->db->query($sql)->result_array();
var_dump($rec);
return $rec;
}

11 => 
    array (size=27)
      'estate_type_id' => string 'DZI' (length=3)
      'use_region' => string '+' (length=1)
      'use_town' => string '+' (length=1)
      'use_district' => string '+' (length=1)
      'use_address' => string '+' (length=1)
      'use_floor_no' => string '-' (length=1)
      'use_floors' => string '-' (length=1)
      'use_area' => string '+' (length=1)
      'use_rooms' => string '' (length=0)
      'use_offices' => string '+' (length=1)
      'use_year_built' => string '+' (length=1)
      'use_ownership' => string '+' (length=1)
      'use_standard' => string '+' (length=1)
      'use_house' => string '+' (length=1)
      'use_buildings' => string '+' (length=1)
      'use_garrage' => string '0' (length=1)
      'use_parking' => string '+' (length=1)
      'use_kitchen' => string '+' (length=1)
      'use_balcony' => string '-' (length=1)
      'use_gas' => string '+' (length=1)
      'use_current' => string '+' (length=1)
      'use_sewerage' => string '+' (length=1)
      'use_furniture_type' => string '-' (length=1)
      'use_equipment' => string '+' (length=1)
      'use_guard' => string '+' (length=1)
      'use_pictures' => string '+' (length=1)
      'use_remarks' => string '+' (length=1)

Czy ktoś umie to wytłumaczyć? Byłbym wdzięczny za pomoc.