double and single quotes in text fields acting up... help please

Posted on 16th Feb 2014 07:03 pm by admin

Single quotes, when entered into a text field, create an sql error upon Submit. It seems to create the query OK but says there's an SQL syntax error and stalls out on that field.

Also any time a double-quote is in a text field, all characters to the right of it GET DELETED upon Submit and have to be re-entered before trying to Submit form again.

The two larger textarea fields in the form seem to handle the single and double quotes perfectly. Stripslashes functions correctly and no deleting of data. Yet my code doesn't treat these two areas any differently that the text fields(!?)

I have used stripslashes on all posted variables

http://www.cmfsc.ca/coachingapplication_Feb10email.php

Thanks for any help

Your Answer:

Login to answer

Other forums

I face problems to extract data from one table and insert it in another one
Hi,

For modifications, I have to extract data from one table and insert it in another one

Email Form Syntax Issue
I need the TO: in email to display To: CEO instead of To: abc@mail.com

How to alter the scri

OOP help
okay so i have a class im making it has everything setup i just need to randomize the 2 variables an

JQuery, Masterpage, and Control issue
Hey everyone, I am using JQuery in several sites so I thought it would be best to place the library

Get Total From While Loop
I'm trying to get the total for each product and add them for a Grand Total to list outside the loop

EU VAT Package 2010
Does any one know whether SAP will be developing new reporting functionality due the new VAT rules t

How to search for several parameters from objects in a database?
I have a database with lots of information about objects.
Now I would like to search for 4 or 5 p

Can php detect connection speed and thereafter swap out elements?
No code to post, lads, yet. Just looking for a yay or nay at this stage:

Can a php script be

How to load mysql (and other) extensions into PHP
How to load mysql (and other) extensions into PHP PHP Development forum discussing coding practices,

Echoing ASCII code
I have a php page that splits a string into chars and then echoes the ASCII code for each char. I'm