This is probably really simple, and I'm going to kick myself for not seeing it, but hey.
I'm trying to execute the following the following query:
SELECT FROM jobs WHERE active = "1" AND ( job_title LIKE "%one%" OR job_title LIKE "%two%" OR job_title LIKE "%three%" OR description LIKE "%one%" OR description LIKE "%two%" OR description LIKE "%three%" ) AND salary >= "15000" AND salary <= "20000" AND ( region_id = "28" OR region_id = "11" ) AND ( industry = "38" OR industry = "9" OR industry = "24" ) LIMIT 0 , 20
And MySQL is throwing this error:
#1064 - 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 'FROM jobs WHERE active = "1" AND (job_title LIKE "%one%" OR job_title LIKE "%two' at line 1
As I said, I've been staring at this thing until my eyes bleed and I can't spot my error, so I was hoping someone here could chip in if they can see it?
Glad you got it sorted out, we've all been there. :)
Why is it always after you've publically humiliated yourself you realise these things? :(
There's a psychological effect to publishing it online -- you say to yourself, "While I wait for an answer I can think about something else." Once your subconscious mind gets ahold of it, it often finds the answer on it's own.