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

Error querying database.
I get the above error when trying to insert some values to a datatable.
Here's the code :

Unifying logins of two different scripts
I have two different game scripts which I want to embed on my own site. The problem is I don't want

POST into Array problem
Hi Chaps,

I have a repeat region, displaying rows of data: jobid, fromtable, translatorcharge

Error in SQL Syntax HELP!!!
I have this page:

Code: <?php

session_start();

//connect to server and s

Backflush
I am looking for a report in SAP that would give me a list of all parts that are populated with a ba

Just wondering what you think about my site
I am new to phpfreaks i just seen this form and thought it would be cool to see what other thought a

Help with setcookie()
Merry Xmas to those on this foruum
Older guy here with some experience but not allot so please be

value not going in data base
hello friends....
i am having a working javascript....when i am selecting any

Calculus Help (and by help I mean homework)
Hrmmm, I hate posting about math homework, partly because it's homework, and partly because I hate w

Is it a good practice to store user info. in sessions?
I am making a user class for my script which stores all the user information in sessions. It takes u