How to update "domainstatus" for a product/service via SQL query?

[KuJoe]

I can't figure this out for the life of me. I have an external script that runs via a cronjob and I can get it to suspend the actual service and open a ticket but I want the script to change the service to "Suspended" in WHMCS so if the client logs in they'll see it suspended with a specific reason. I can update the suspendreason field but I can't change the domainstatus for some reason. I'm thinking it has something to do with the enum values but I don't know what that means and my searches haven't helped either.

 

Here's the code I'm trying to run:

$mysqli->query("UPDATE `tblhosting` SET domainstatus = 'Suspended' WHERE `id` = '". $id ."'");