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

disabling a button server-side then re-enabling client-side breaks button postback
I have a tabbed container and a button (not in the container) on a page. If the first tab is selecte

mysql UPDATE request not working and driving me crazy!!!
Hi,

I have been stuck on this for ages.

Quite simply I am trying to update my database

b+ tree
Hi
can every body help me about b+ tree ?(insert & delete)

PHP onsubmit in the form not going to the fuction.
I have a form through ‘onsubmit’ calling a function validation(). But not going to the

WS-Security PL/SQL Forms
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Prod
PL/SQL Release 10.2.0.2.0 - P

first few characters only
hi, does anyone know how to use PHP to take the first few words of a text and limit them? i have see

A rank users order by points
I want to make an insert from table 'rank' , with number (rank) from the cod blow, to fild users.ran

Multiple includes losing variables
Hey all,

just starting out w php and ran into a problem pretty quickly. I'm
including seve

Filtering an Array Based on Value
I have a very simple script set up that pulls data from a database and is output using this code:

switch not getting value
what am i doing wrong?
i want to populate the country list according to the category
i want to