如何在调用“conversationID”时获得单行数据?
目前,当我调用“conversationID = 0”时,它会显示所有“conversationID”的值为0的行。
这是关于消息表的问题。
|ID|conversationID|from|to|
|1|0|3|4
|2|0|4|3
|3|0|3|4
|4|1|2|4
|5|1|4|2
控制器
public function index()
{
$conversations_inbox = $this->conversation_model->get_conversation_inbox($this->user->info->ID);
$this->template->loadContent("conversations/index.php", array("conversations_inbox" => $conversations_inbox,)
);
}
模型
public function get_conversation_inbox($userid) {
$query = $this->db->where("conversations.from_user = ". $userid)->or_where("conversations.to_user = ". $userid)->select("*")->from("conversations")->join("conversation_message", "conversation_message.conversationID = conversations.conversationID")->order_by("conversation_message.date", "DESC")->get();
return $query->row();
}
<?php
foreach ($conversations_inbox as $c) { ?>
<li class="mail-starred">
<div class="mail-from"><a href="<?php echo base_url("conversations/message/") . $c['conversationID'] ?>"><img src="<?php echo base_url() . $c['store_picture'] ?>" style="width: 40px;height: 40px;margin-right: 10px;">
<?php echo $c['store_name'] ?></a></div>
<div class="mail-subject">
<a href="<?php echo base_url("conversations/message/") . $c['conversationID'] ?>">Test</a>
</div>
</li>
<?php } ?>
return $query->row();
- Madhawa Priyashantha