4,250
社区成员
发帖
与我相关
我的任务
分享
public function searchFri($p_user,$p_acc){
$frseq = $this->_db->fetchAssoc(
"SELECT user_account,user_seq,user_name,user_iconpath,user_iconname FROM t_user WHERE user_account = :user",
array('user' => $p_acc)
);
if(count($frseq)<=0)
return '0';
else{
$select = $this->_db->fetchAssoc("SELECT * FROM t_relation WHERE relation_user = :user and relation_friend = :friend and relation_public=0",array('user'=>$p_user,'friend'=>$frseq['user_seq']));
if(!count($select)){
return '1';
}
else
return $frseq;
}
}
$num = $this->db->fetchRow('select count(id) as num from table where .... ' );
echo $num['num'];