Question

我有一个简单的信使系统,我要展示既得信息,又电文。相关表格/栏目载列如下:

User:

id | firstName | lastName 
-------------------------

Message:

id | fromid | toid | message
----------------------------

I m 座标为:

SELECT message.id, `fromid`, `toid`, `sent`, `message`, message.email, `read`, user.id, `firstName`, `lastName`, `rank`   
FROM message LEFT JOIN `user` ON message.fromid = user.id OR message.toid = user.id  
WHERE `toid` =  $id  OR `fromid` =  $id   
ORDER BY `read` DESC, `sent` DESC";

(为了在我的PHP书写中进行分类,我确实:)

$received = array();  
$sent = array();

while ($dbRow = mysql_fetch_array($query)) {
    if ($dbRow[ toid ] == $id) {
        $received[] = $dbRow;
    } else if ($dbRow[ fromid ] == $id) {
        $sent[] = $dbRow;
    }
}

因此,我想选取以下信息:toid或 fromid等于用户 sid,然后加以分类(即,如果用户的复制件载于toid)。该栏从其他用户发送至用户,而如果载于<条码>,则从<>>。用户一栏将其发送到其他人。

The query almost kind of works, except the $sent[] array contains duplicates: it lists each row twice, once displaying the user s name and the other displays the receiver s name. I can kind of see why, but I don t know what to do to fix it.

我不知道我是否需要调整我的卡片或我的PHP书写,因此我已经把这两条都包括在内。

我知道,我只能把它分成两个问题,但Im试图改进我的工作,并更多地了解日本海洋研究网的工作。

Answer 1

有两个国家加入,即加入“从”到“到”的用户表,另一个时间是“到”的,例如:

SELECT message.id, `fromid`, `toid`, `sent`, `message`, message.email, `read`, fromuser.*, touser.*
FROM message LEFT JOIN `user` fromuser ON message.fromid = user.id 
LEFT JOIN `user` touser ON message.toid = user.id  
WHERE `toid` =  $id  OR `fromid` =  $id   
ORDER BY `read` DESC, `sent` DESC";

Answer 2

您是否尝试过<条码>。看看MySQL想更多地学习。

友情链接