START TRANSACTION;

-- Your SQL statements here
UPDATE tbl_users
SET manager_id = {$data['tbl_manager_id']}
WHERE tbl_users.tbl_department_id = {$data['tbl_department_id']} 
      AND tbl_users.id != {$data['tbl_manager_id']}
      AND tbl_compnay_department_names.department_manager_id = {$data['tbl_department_id']};

-- Check if the update affected any rows
IF ROW_COUNT() > 0 THEN
    COMMIT; -- If at least one row was updated, commit the changes
ELSE
    ROLLBACK; -- If no rows were updated, rollback the changes
END IF;