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

Image DPI
Hi.

I allow users to upload images, the user then is able to adjust several settings for the

Save User Inputs while javascript reloading!
hi..
i have written a PHP code in which i reload the page when user selects a value in dropdown..

Give me all your tricks for minimizing jar file size

Hi, I'm coming close to releasing my J2ME game... I am kicking up against the 64k size barrier w

Help With editting and deleting form
So look at this image :

http://img194.imageshack.us/img194/8272/snapshot5f.png
This table

Problem with HTML form
Hello,

I made a HTML form with some fields and check box.
Everything works fine except whe

PHP page loading in Firefox but not in IE
hello,

i am currently doing a project in PHP and i have a problem. If I view the project in M

xml element exists
Code: [Select]<?xml version="1.0"?>
<Addresses>
<

Gaining access to Drop Down Menu Variable
code is below, I am creating a drop down menu. I want to echo the value selected in the drop down me

php redirecting
i wont open a new thread but i have a question about redirecting....
i wonder why my code doesnt

What am I missing here? Help!
Hello all!. I can't seem to get this working right. Well - it renders right, but something is goin