Running a Basic Search

[eluser]Jelmer[/eluser]
Take a look at CI's built in query-builder: Active Record.

Here's a short example:

Code:

$fname = $this->input->post('fname');
$city = $this->input->post('city');

if ($fname)
    $this->db->where('fname', $fname);
if ($city)
    $this->db->where('city', $city);

$query = $this->db->get('table_name');

$result = $query->result();