大佬如何查询当前用户在member_auth表中的auth_
开源系统 更新 2019-07-02 16:42:00
laowt
laowt
大佬，如何查询当前用户在member_auth表中的auth_glbh字段和另一个用户在表member_auth中的字段auth_usn内容相同，就显示另一个用户在表中的内容，主要用于归类管理。
\Poscms\Service::M()->table("member_auth")->where("auth_usn", 当前用户的auth_glbh字段值)->where("uid<>当前用户的uid值")->getRow();{php $g=\Poscms\Service::M()->table("member_auth")->where("auth_usn","auth_glbh")->where("uid<>uid")->getRow();} {if $g} {php $a = dr_member_auth($g.uid);} : {$a.auth_gllx}{$a.auth_name}{dr_linkagepos('address',$a.auth_quyu, " - " )}{$a.auth_gldz}{$a.auth_usn}{/if}{php $g=\Poscms\Service::M()->table("member_auth")->where("auth_usn","auth_glbh")->where("uid<>uid")->getRow();} {if $g} {php $a = dr_member_auth($g.uid);} : {$a.auth_gllx}{$a.auth_name}{dr_linkagepos('address',$a.auth_quyu, " - " )}{$a.auth_gldz}{$a.auth_usn}{/if}请帮我看看{php $g=\Poscms\Service::M()->table("member_auth")->where("auth_usn","auth_glbh值，不能填字母")->where("uid<>".$member.uid)->getRow();}第一个条件需要填变量{php $g=\Poscms\Service::M()->table("member_auth")->where("auth_usn", $member.auth_glbh)->where("uid<>",$member.uid)->getRow();}这样好像也不对{php $g=\Poscms\Service::M()->table("member_auth")->where("auth_usn",dr_member_auth($member.uid)['auth_glbh'])->where("uid<>".$member.uid)->getRow();}回复迅睿框架创始人