public function SetReadChat($id) { $id_user = Session::GetSession("login", "id"); $query = "SELECT id_submensajeria as 'id_sub' FROM lieisoft_submensajeria \n WHERE lieisoft_submensajeria.id_usuario \n NOT LIKE '{$id_user}' \n AND id_mensajeria LIKE {$id}\n AND lieisoft_submensajeria.leido LIKE 0\n ORDER BY fecha DESC , hora ASC"; $result = parent::RawQuery($query); foreach ($result as $value) { $id_sub = $value['id_sub']; $query = "UPDATE lieisoft_submensajeria" . " SET lieisoft_submensajeria.leido = 1" . " WHERE id_submensajeria LIKE {$id_sub} "; parent::beginTransaction(); parent::exec($query); parent::commit(); } }