voting error

I have got an error on the voting on videos.bellaedward-cullen.com, this is waht it says in the view polls in the admin....

Quote:

---

POLL:[Start Date:2008-12-03 End Date:2008-12-31 ]s
Qty: What Do You Think Of The Film?
ERROR: Unable to execute query

SELECT count(*) as poll_id from vote_result WHERE answer='I Haven't Seeen It Yet, Dont Plan too!'

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 't Seeen It Yet, Dont Plan too!'' at line 1

---

I would delete the poll but it doesnt give me that option.

Your error is due to one of your answers having an apostrophe in it (a ' in Haven't). You will need to remove that.

thanks, i have sorted it out now as well :D