error ....

[TheOriginalNutter]

http://www.radbmx.co.uk/mkportal/modules/coppermine/displayimage.php?album=3

shows

ERROR: Database error.
Cannot execute the query: INSERT INTO mkpcpg_usergroups VALUES (24, 'SMF_Hoffman's Love Child', 0, 0, 1, 1, 1, 1, 1, 1, 0, 3, 0, 5, 3)
MySql Error returned: 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 Love Child', 0, 0, 1, 1, 1, 1, 1, 1, 0, 3, 0, 5, 3)' at line 1
MySql Error code: 1064

[SteveD]

yeah i always get that error if i click on the big pic lower down the home page

[SteveD]

I know the reason for this problem, Its an SQL thing . . .

'SMF_Hoffman's Love Child'

should read

'SMF_Hoffman''s Love Child',

thats two single quotes eg '' and not a double quote eg "

[TheOriginalNutter]

addslashes() or htmlentities() then .... why is it inserting anyway?

webmistress!!