$sql="update order_list.*,customer.status,customer.comment_status,customer.name
from order_list
left join customer on order_list.id_card=customer.id_card
where orderID='$_GET[orderid]'
set customer.status='4' customer.comment_status='$_GET[comment]'";