•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 374,013 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,682 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser:
Views: 1689 | Replies: 1
 |
•
•
Join Date: Oct 2005
Posts: 13
Reputation: 
Rep Power: 3
Solved Threads: 0
Newbie Poster
Hi,
got another problem.
I have an interface that uses javascript to generate the Mysql WHERE condition of a query it posts to the a PHP page that retrieves values from the database. it works fine as usual on my local pc. but i when i uploaded it to my web host machine. it gave the error...
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 '\\\'%government college%\\\') LIMIT 0, 1' at line 1
SELECT * FROM Applicants WHERE (secSchName like \\\'%government college%\\\') LIMIT 0, 1
on my local pc the code appears as :
SELECT * FROM Applicants WHERE (secSchName like \\\'%government college%\\\') LIMIT 0, 1
i can see the error is from the \\\ but how do i correct it since i didnt put there in the first place.
got another problem.
I have an interface that uses javascript to generate the Mysql WHERE condition of a query it posts to the a PHP page that retrieves values from the database. it works fine as usual on my local pc. but i when i uploaded it to my web host machine. it gave the error...
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 '\\\'%government college%\\\') LIMIT 0, 1' at line 1
SELECT * FROM Applicants WHERE (secSchName like \\\'%government college%\\\') LIMIT 0, 1
on my local pc the code appears as :
SELECT * FROM Applicants WHERE (secSchName like \\\'%government college%\\\') LIMIT 0, 1
i can see the error is from the \\\ but how do i correct it since i didnt put there in the first place.
Last edited by iketunde : Oct 17th, 2005 at 9:03 am. Reason: typo error
•
•
Join Date: Oct 2005
Location: Burlington, Ontario
Posts: 26
Reputation:
Rep Power: 3
Solved Threads: 0
Light Poster
What is the SQL query in the code that is on your local PC? Are you using some sort of design tool to build your app? More code from where your generating this query would be helpful.
Wally
www.power-coder.net
Wally
www.power-coder.net
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
Linear Mode
Similar Threads
- test mysql query for no results (PHP)
- Double MySQL Query (PHP)
- MySQL query's (MySQL)
- Change MySQL Query Timeout Period (MySQL)
- autogenerated mysql query with javascript (PHP)
- probelm with autogenerated mysql query (PHP)
Other Threads in the MySQL Forum
- Previous Thread: How To Create Foreign Key
- Next Thread: phpmyadmin --- several services to use one database
