I have this code line:function update($data) { $q = "SELECT id FROM estates WHERE list_id = '".mysql_real_escape_string(trim($data['list_id']))."'"; $r = $this -> db -> query($q); if ($rw = $r -> fetchRow()) { $eid = $rw['id']; } $q = "UPDATE estates SET title = '".mysql_real_escape_string($data['title'])."', country = '".mysql_real_escape_string($data['country'])."', region = '".mysql_real_escape_string($data['region'])."', zone = '".mysql_real_escape_string($data['zone'])."', city = '".mysql_real_escape_string($data['city'])."', price = '".mysql_real_escape_string($data['price'])."', currency = '".mysql_real_escape_string($data['currency'])."', unit = '".mysql_real_escape_string($data['unit'])."', exclusivity = '".mysql_real_escape_string($data['exclusivity'])."', ad_type = '".mysql_real_escape_string($data['ad_type'])."', estate_type = '".mysql_real_escape_string($data['estate_type'])."', description = '".mysql_real_escape_string($data['description'])."', date_in = '".mysql_real_escape_string($data['date_in'])."', date_out = '".mysql_real_escape_string($data['date_out'])."', rooms = '".mysql_real_escape_string($data['rooms'])."', dorms = '".mysql_real_escape_string($data['dorms'])."', total_mp = '".mysql_real_escape_string($data['total_mp'])."', util_mp = '".mysql_real_escape_string($data['util_mp'])."', marime_lot = '".mysql_real_escape_string($data['marime_lot'])."', agent = '".mysql_real_escape_string($data['agent'])."', office_id = '".mysql_real_escape_string($data['office'])."' WHERE list_id = '".$data['list_id']."'"; //echo "\n\n$q\n\n"; if ($res = $this -> db -> query($q)) { return $eid; } else { return false; } } how can i transform it into php to select from the database all the data from the zone section. In my php file I have this code line : $r = $estate->db->query($q);if ($rw = $r -> fetchRow()) { $tot = $rw['tot'];}$smarty->assign("total_estates",$tot); Please help