Originally Posted by
Brian1234
OK, thanks! Would you take a look and see if this looks appropriate for zen-cart?
INSERT INTO orders_status_history (orders_id, orders_status_id, date_added, customer_notified, comments)
VALUES ($id, 5, '2010-03-03 23:00:00', 0, 'order status was changed to History by Brian')
There, $id represents the number of each actual order I have changed the status of. The rest of the fields would be static values exactly as shown where 5 is my custom History status, then that datetime, notification value and comment.
I'm not touching orders_status_history_id in the statement because it's an auto_increment and I think it will handle itself. I'm seeing some indexes (PRIMARY and idx_orders_id_status_id_zen) but am unsure if I have to do anything with those.
Bookmarks