Member Avatar for iketunde

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 webhost 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.

  • 3 Contributors
  • 2 Replies
  • 164 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by zippee
Member Avatar for PoA

SELECT * FROM Applicants WHERE secSchName like '%government college%' LIMIT 0, 1;

Hopefully, it works.

Member Avatar for zippee

Is it allow LIMIT 0 in SQL query? This means there will return no result...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.