$this->db->orderby ?

$this->db->orderby ?

El Forum
Unregistered

#10

03-09-2010, 03:48 PM

[eluser]outtolunch[/eluser]
got this thing working at the end.

$query = "SELECT * FROM companies WHERE area='$area' AND category='$category' AND status='active' ORDER BY sub_area='$sub_area' DESC, sub_area DESC LIMIT $limit OFFSET $offset";

thats the query.

thanks again everyone, who gave advice.

Messages In This Thread

$this->db->orderby ? - by El Forum - 03-09-2010, 06:03 AM

$this->db->orderby ? - by El Forum - 03-09-2010, 07:13 AM

$this->db->orderby ? - by El Forum - 03-09-2010, 07:17 AM

$this->db->orderby ? - by El Forum - 03-09-2010, 07:22 AM

$this->db->orderby ? - by El Forum - 03-09-2010, 10:05 AM

$this->db->orderby ? - by El Forum - 03-09-2010, 12:50 PM

$this->db->orderby ? - by El Forum - 03-09-2010, 01:05 PM

$this->db->orderby ? - by El Forum - 03-09-2010, 02:50 PM

$this->db->orderby ? - by El Forum - 03-09-2010, 03:14 PM

$this->db->orderby ? - by El Forum - 03-09-2010, 03:48 PM

$this->db->orderby ? - by El Forum - 03-09-2010, 05:36 PM

$this->db->orderby ? - by El Forum - 03-09-2010, 07:52 PM