To do a query before inserting data in mySQL

[eluser]Mike Ryan[/eluser]
You need to include the variable name (e.g. $email) in the function declaration:

Code:

function emailcheck($email) <-- HERE
  {
  $query = $this->db->query(‘SELECT field_04 FROM contact’);
  $this->db->where(‘field_04’, $email); <-- AND HERE
  if ($query->num_rows() > 0)
  {
  $this->load->view(‘myform’);
  }
  }

Also, usually the function should just return true or false, and let the controller handle what happens next:

Code:

function emailcheck($email)
  {
    $query = $this->db->query(‘SELECT field_04 FROM contact’);
    $this->db->where(‘field_04’, $email);
    if ($query->num_rows() == 0)
    {
        return true;
    else
    {
        $this->form_validation->set_message('emailcheck', 'Email already registered');      
        return false;
    }
  }