简单的查询使用CONCAT IF
$query="SELECT CONCAT(id_state,'_',id_city) AS id_state_city,IF(state=city,state,CONCAT(state,'_',city))
AS state_city FROM #__jobs_job WHERE employer_id=".intval($masteruser->id)
简单的查询使用CONCAT IF
$query="SELECT CONCAT(id_state,'_',id_city) AS id_state_city,IF(state=city,state,CONCAT(state,'_',city))
AS state_city FROM #__jobs_job WHERE employer_id=".intval($masteruser->id)