ecshop后台首页mysql_ecshop后台订单列表页面想显示省市区报错

MySQLservererrorreport:Array([0]=>Array([message]=>MySQLQueryError)[1]=>Array([sql]=>selectregion_namefrom`sheshou`.`ecs_region`whereregion_id=)[2]=>Array([error]=>Youhav...

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => select region_name from `sheshou`.`ecs_region` where region_id= ) [2] => Array ( [error] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 ) [3] => Array ( [errno] => 1064 ) )

admin/order.php sql语句

$row[$key]['province']=$GLOBALS['db']->getOne("select region_name from ".$GLOBALS['ecs']->table('region')." where region_id=".$value['province']);

$row[$key]['city']=$GLOBALS['db']->getOne("select region_name from ".$GLOBALS['ecs']->table('region')." where region_id=".$value['city']);

$row[$key]['district']=$GLOBALS['db']->getOne("select region_name from ".$GLOBALS['ecs']->table('region')." where region_id=".$value['district']);

求大神给看看哪错了

展开