I could use
PHP Code:
$order_number = zen_db_prepare_input($_POST['order_number']);
to get the order number, then modify my code below to get it to update
PHP Code:
$order_status = '6';
$return_update = array('orders_id' => zen_db_prepare_input($_POST['order_number']),
'orders_status' => $order_status,
'comments' => zen_db_prepare_input($_POST['action']),
'comment_by' => 'c'
);
zen_db_perform(TABLE_ORDERS, $return_update, 'update', "orders_id = '" . $order_id . "'");
Now if the code works, I just need that update to be done when they hit submit.