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

Php - mysql select?
hi, i have this code:

Code: <?php
session_start();
// dBase file
include &quo

need to apply an if/else statement to Tim Thumb script
Not sure how to work this. I essentially want to call a variety of image sizes based on which style

Most basic form question ever?
Hello,

I want to use this snippet to make sure the fields in a form are ok before processing

PHP mail() rejected by SMTP
I'm currently working on a newsletter application which is installed on a windows 2003 server runnin

Having a problem get the selected item from a drop down menu
I have been looking at this for days now.

I have a drop down menu that get it's values from a

server trace logs
could any one tell me from where do i get error logs in xMII??I want to check the reason for dtabase

I need an iframe that calls up a different page according to the date
hi

I don't know any php (only html) and I urgently need to do the following:

I need a

Clean URLs
Hi I was wandering if anyone has ever implemented URLs on their PHP run website using URLS like wiki

Bit manipulation program with binary operations
My homework is to create a program to scan in and add binary numbers and print them like so

trim function issues
Hi guys, total noob here...

So I've been tinkering around with a html and am using php to em