Auto update Order Status via barcode on invoice

To do this right, if I used a variable similar to:
$status = (order_status='4');

I could then use that variable for the Update Statement SET orders_status='" . $status . "' and the Insert Statement would reference the same thing properly.

How would that variable define "Order Status id #4" correctly?

$status = 4;

Kudos DrByte

I had put quotes around the 4 at one time, didn't know you can drop them all together. I look forward to presenting this module to ZC very soon here.