标题: 新功能:聊天模式收件箱
时间: 2013-07-21
select uid,name from user where user.uid in (select byuid from msg where msg.uid=? union select uid as byuid from msg where msg.byuid=?)
本来还准备更复杂的(用join语句来联合msg表进行time排序),但是由于无法排除重复数据,我只好改用查询出所有用户,然后用php排序了。『回复列表(8|隐藏机器人聊天)』