public static function removeProvider($id) { $db =& DB::singleton(); $res = 0; $delete_products = "delete from providers_products where providers_products.prov_id={$id}"; $delete_provider = "delete providers from providers where providers.id={$id}"; $res = $db->getAffectedRows($delete_products); $res = $db->getAffectedRows($delete_provider); self::$providers = null; return $res; }