Simple error - CodeIgniter

[eluser]anna16[/eluser]
Hello guys

I have this codes below,

Code:

$query = $this->db->query('SELECT email_address FROM membership WHERE email_address="$this->input->post('email_address')"');

And this is the error message,

Code:

Parse error: syntax error, unexpected T_STRING

I hope someone can help me.

thanks.

[eluser]Santiago Dimattía[/eluser]

Code:

$query = $this->db->query('SELECT email_address FROM membership WHERE email_address="' . $this->input->post('email_address') . '"');

[eluser]Dennis Rasmussen[/eluser]

Code:

$query = $this->db->query("SELECT email_address FROM membership WHERE email_address = ?",  array($this->input->post('email_address')));

Doing it this way and you won't get any SQL injection (hack) into your query.