autogenerated mysql query with javascript

Expand Post »

Hello,

I created this page. it contains textareas and checkboxes. when user enters information or check any of the checkboxes. this translates to a conditioned query.i achieve this using javascript. u can find the url @

www.laterallinks.com\search.htm

try entering gibberish and any of the fields and click on the fetch applicants button.

it should check the database for possible qualified entries.

I test this on my local pc at home. it works very fine. on my local machine it executes fine

for example on my local pc if i enter washington high in the secondary school textarea this is what i get

SELECT * FROM Applicants WHERE (secSchName like \'%washington high%\') LIMIT 0, 1

but when i upload it to my webhost machine. it introduces extra slashes as shown below.
how do i stop this from happening.

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '\\\'%washington high%\\\') LIMIT 0, 1' at line 1

SELECT * FROM Applicants WHERE (secSchName like \\\'%washington high%\\\') LIMIT 0, 1

Similar Threads

test mysql query for no results in PHP
Double MySQL Query in PHP
MySQL query's in MySQL
Change MySQL Query Timeout Period in MySQL
probelm with autogenerated mysql query in PHP

iketunde

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

13 posts
since Oct 2005

Permalink

Oct 18th, 2005

Re: autogenerated mysql query with javascript

I dont know why, but maybe I can help. I at least know why there are three slashes!

Im sure you know that a back slash makes the next character literal.

The best example is a string that looks like this
var = "here is a \"quote\""

you know that you need to have \" like this in a string because otherwise it will interfere with the outer quotes which define the string as a whole. Well for some reason the code is anticipating needing a literal quote and doing this
\\\'

So, The first \ makes the second \ literal. the third \ makes the ' literal. It wants the end result to be \'

Like I said I dont know enough about what your doing to help you solve but at least I can help with explaining that much...

good luck

Brad W.
AZPixels

bwest

Reputation Points: 14

Solved Threads: 1

Junior Poster in Training

Offline

57 posts
since Jul 2004

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: probelm with autogenerated mysql query

Next Thread in PHP Forum Timeline: Php With Pdf

DaniWeb Message

Cancel Changes

User Name
Password