prashanth.crs

Hi I have a script which basically inserts into MySql database using PHP scirpt the valuess tored in textoxes. the problem comes when someone has entered an apostrohe -'- in the text box...then it always returns an error saying i cannot enter... heres the script error...WHEN I ENTER ' IN ANY OF THE FIELDS Error: Unable to perform update: UPDATE agencies SET date_last_updated = '2006-09-22 16:24:29',agency_name = 'testing99',program_name = 'testing99',address_one = 'testing99'',address_two = 'testing99',city = 'testing99',state = '',zip = '',phone = '',fax = '',web = 'testing99',email = 'testing99',hoursoperation = 'testing99' WHERE aid = '221'; :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 'testing99',city = 'testing99',state = '',zip = '',phone = '',fax