md5 to sha1

[eluser]clintonbeattie[/eluser]
Hi,

I have a function to add an encrypted password to a database which is this...

Code:

function validate()
    {
        $this->db->where('username', $this->input->post('username'));
        $this->db->where('password', md5($this->input->post('password')));  
        $query = $this->db->get('membership');
        
        if($query->num_rows == 1)
        {
            return true;
        }
        
    }

What I would like to do is use SHA1. I have added an encryption key to my config file and added this function to my model...

Code:

function _prep_password($password)
{
     return sha1($password.$this->config->item('encryption_key'));
}

How would I go about using this in my current code? This maybe?

Code:

$this->db->where('password', md5($this->input->post(_prep_password($password))));

Thanks for any advice.

C