Mysql giving error with '
I have built a php script that inserts data into a mysql table but everytime I try and insert data with an ' it returns an error:
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 's', 'step')' at line 2
in this particular case I was trying to insert the word "dave's"
What's going on? any help woud be appreciated Thanks