Simple Ci Queries...............

[eluser]noname525[/eluser]
vv

[eluser]InsiteFX[/eluser]
You should be using the second parameter of $this->input->post to xss_clean your data before inserting it in to your database tables.

Code:

// insert
$name = $this->input->post('country', TRUE);

// update
$name=$this->input->post('country', TRUE);
$this->db->where('id',$this->input->post('id', TRUE));

[eluser]InsiteFX[/eluser]

Code:

// list
function list_country($table){
         $this->db->order_by('id','name');
         $query=$this->db->get($table);

         return $query;
    }

// delete
function delete($id , $table)
     {
       $data=array('id' => $id);
       $this->db->delete($table, $data);
     }