SOLVED: Database help |
[eluser]rvillalon[/eluser]
How would I transform this: $sql = "SELECT message, date_created, username FROM shoutbox s, users p WHERE p.id = s.uid ORDER BY s.date_created DESC"; $query = $this->db->query($sql); into a format like this: $this->db->where("did", $did); $this->db->limit(10, 0); $this->db->order_by("date_created", "desc"); $this->db->from(self::TBL_SHOUTBOX); $result = $this->db->get();
[eluser]georgerobbo[/eluser]
http://ellislab.com/codeigniter/user-gui...eries.html |
Welcome Guest, Not a member yet? Register Sign In |