Quote:
Originally Posted by curtiss
What is the error that it's showing?
Which method are you using for your AJAX request? Our you using POST or GET?
|
I use the GET method. The error says:
Quote:
SELECT * FROM bible WHERE 1=1 AND
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 '' at line 1
|
on Page 2.
Page 1's sql says:
Quote:
SELECT * FROM bible WHERE 1=1 AND
CASE WHEN text_data LIKE '%offering%' THEN 1 ELSE 0 END +
CASE WHEN text_data LIKE '%tabernacle%' THEN 1 ELSE 0 END +
CASE WHEN text_data LIKE '%congregation%' THEN 1 ELSE 0 END +
CASE WHEN text_data LIKE '%Aaron%' THEN 1 ELSE 0 END > 3 LIMIT 0, 10
|