mysql联表查询语句示例
ps:本人亲测,阿里云2核4G5M的服务器性价比很高,新用户一块多一天,老用户三块多一天,最高可以买三年,感兴趣的可以戳一下:阿里云折扣服务器
示例:
"select a.trade_no,a.add_time,a.amount,a.status,b.nickname
from
pigcms_user_money_withdrawal as a
join
pigcms_user as b
on a.user_id=b.uid
join
pigcms_user as c
on c.user_id=b.uid
where
a.user_id='".$uid."'
order by
add_time desc limit ".($page1*10-10).",10";