可以用左连接查询,一个sql语句就行了!通过users表的user_admin_id关联admin_user表的user_id(因为同为管理员id ); $sql = "select a.agency_id from users as u left join admin_user as a on u.user_admin_id=a.user_id where u.USER_ID =$_SESSION[user_id";sql语句没测试过,但思路是没问题的
我看上去没什么问题~ 麻烦楼主补一句return $agency_id;
谢谢大家,我修改成这样,就有结果了……测试通过……呵呵。 function get_agency_by_bsc() {
$sql = "SELECT user_admin FROM ".$GLOBALS['ecs']->table('users')." WHERE user_id = '$_SESSION[user_id]'"; $res = $GLOBALS['db']->getRow($sql); $user_id= $res['user_admin']; $sql = "SELECT agency_id FROM ".$GLOBALS['ecs']->table('admin_user')." WHERE user_id = '$user_id' "; $res = $GLOBALS['db']->getRow($sql); $agency_id= $res['agency_id']; return $agency_id;}
$sql = "select a.agency_id from users as u left join admin_user as a on u.user_admin_id=a.user_id where u.USER_ID =$_SESSION[user_id";sql语句没测试过,但思路是没问题的
麻烦楼主补一句return $agency_id;
function get_agency_by_bsc()
{
$sql = "SELECT user_admin FROM ".$GLOBALS['ecs']->table('users')." WHERE user_id = '$_SESSION[user_id]'";
$res = $GLOBALS['db']->getRow($sql);
$user_id= $res['user_admin'];
$sql = "SELECT agency_id FROM ".$GLOBALS['ecs']->table('admin_user')." WHERE user_id = '$user_id' ";
$res = $GLOBALS['db']->getRow($sql);
$agency_id= $res['agency_id'];
return $agency_id;}