Apostrophe in form causing Error Number: 1064

[eluser]Craig A Rodway[/eluser]
You have a couple of options - have a look here.

I'd recommend the Query Bindings option, so your query would be:

Code:

$sql = "INSERT INTO participants (id,YourName,email,comments) VALUES (NULL, ?, ?, ?)";
$this->db->query($sql, array($YourName, $email, $comments));