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