prashanth.crs
-
Posts
1 -
Joined
-
Last visited
Never
We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.
Problem with Apostrophe in textbox
in MySQL Help
Posted
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