Quote:
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 ') AND ((1 = 1)) AND ((1 = 1)) AND users.travel = 2 ORDER BY users.dateEdited DES' at line 35
I have tried everything to turn it off using error_reporting(0); in that file and even tried to turn the display off in php.ini but it just does not disappear...
Please kindly if anyone can help me out with it.
this is the code that probably this error is referring to..
Code: Select all
$query = '
SELECT DISTINCT users.ID, users.name, users.personalStatement, users.profilePicture, users.postCode, users.countryID, users.countryCustom, users.firstname, users.surname
FROM users
'.$joinSQL.'
WHERE type = "GRADUATE"
'.$addSQL.' ORDER BY users.dateEdited DESC, users.dateAdded DESC
'; the complete code is too long and it doesn't allow me to post it here, please if any one can help me i'll send the files in a PM may be