mysql 关键字order

今天写sql语句时没有注意order是mysql的关键字：

$table = 'order_goods,order,goods';$join = 'inner,left';$on = 'order_goods.order_id = order.order_id,order_goods.goods_id = goods.goods_id';$field = "order.*,order_goods.*,goods.goods_spec";$where = "";$where .= " order.store_id = '{$_SESSION [store_id]}' && (order.add_time BETWEEN '$searchtime_arr[0]' AND '$searchtime_arr[1]') ";$where .= " && ( order.orderState not in (0,1,2))";$order_list = $model->table($table)->join($join)->on($on)->where($where)->field($field)->limit()->page ()->order('order_goods.order_id desc,order_goods.goods_id desc')->select();

以 order.*查询时会报错，而 order.order_id 不会报错。解决方法：把order.*改成`order`.*。