|
全国
getDb();
$prefix = $cmd->getTablepre();
$sql="select R.id, R.name,R.shortname,R.status,F.title,F.url from
job_spe_region as R ";
$sql.=" left join job_spe_regionfield as F on F.id=R.id ";
$sql.=" where R.upid=0 and R.displayorder<32";
$sql.=" order by R.displayorder asc,R.id asc";
$data['job']['arr_province'] = $db->fetchAll($sql);
?>
|
粤公网安备 44090202000208号