SELECT nickname, speaker,rapper,message, chattime
FROM chats, user
WHERE chats.speaker = user.email
and speaker='[email protected]'
and rapper='[email protected]'mysql 可以查到数据但加上order by后,就查不到信息啦SELECT nickname, speaker,rapper,message, chattime
FROM chats, user
WHERE chats.speaker = user.email
and speaker='[email protected]'
and rapper='[email protected]'
order by chattime desc为什么