Do you guys see anything wrong with this sql query:
SELECT * FROM `visits` WHERE link = '/enrollment_send.php' GROUP BY ip WHERE (`ip` LIKE '%Tampabay%' OR `url` LIKE '%Tampabay%' OR `link` LIKE '%Tampabay%' OR `referrer` LIKE '%Tampabay%' OR `browser` LIKE '%Tampabay%') LIMIT 0, 20
I think I've been looking at it too long, and I can't find the problem. It is giving me a syntax error.
Failed to execute SQL: SELECT * FROM visits WHERE link = '/enrollment_send.php' GROUP BY ip WHERE (ip LIKE '%Tampabay%' OR url LIKE '%Tampabay%' OR link LIKE '%Tampabay%' OR referrer LIKE '%Tampabay%' OR browser LIKE '%Tampabay%') LIMIT 0, 20. 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 'WHERE (((ip LIKE '%Tampabay%' OR url LIKE '%Tampabay%' OR link LIKE '%Tamp' at line 1
Oh man I feel dumb. There are two where clauses....never mind.
