mysql query not liking my smilie

[ashley98860615]

hi

whenever i try to insert the following line with a php/mysql_query it halts:

Cannot perform SQL:

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 ''' at line 1

INSERT INTO `bbcodes` VALUES (15, 'Winker', 'Adds a winking smilie', '

INSERT INTO `bbcodes` VALUES (15, 'Winker', 'Adds a winking smilie', ';)', ';)', '4', '<img src=''../images/smilies/wink.gif'' alt=''Wink'' border=''0''>');

i think it's something 2 do wth the ;. do i need to somehow quote it?

[rincewind456]

You should be using [man]mysql_real_escape_string/man with all your inserts.