How to update orderdata in MySQL

[MLu]

I have added a couple of extra fields to my orders table in MySQL: orders_supplier_onum, orders_supplier_text, where I on a daily basis need to go into table orders for orders with orders_status = "1", and put in info for my suppliers.

 

However, using PHP MyAdmin is too complicated and slow. I have tried then to link to MS-Access, but this is not convenient either.

 

Could anyone in the group suggest an easy and secure way to do this, preferably with only the needed records (orders_status = "1") and only the few fields I need: orders_id, delivery_name, orders_supplier_onum and orders_supplier_text.

 

Thanks for any help!

 

Mogens