Welcome Guest, Not a member yet? Register   Sign In
MySQL query trouble
#5

[eluser]jbads[/eluser]
Code:
SELECT jcc_user.user_id, jcc_user.user_avatar, jcc_user.user_display_name, jcc_user.user_location, jcc_user.user_region, jcc_user.user_skills, jcc_users.username, jcc_users.banned_id FROM (`jcc_user`) LEFT JOIN `jcc_users` ON jcc_users.id = jcc_user.user_id WHERE `user_region` = 'Ruapehu' AND `user_firstname` LIKE '%jet%' OR `user_lastname` LIKE '%jet%' OR `user_display_name` LIKE '%jet%' OR `user_location` LIKE '%jet%' OR `user_skills` LIKE '%jet%' OR `user_interests` LIKE '%jet%' OR `user_work` LIKE '%jet%' OR `user_about` LIKE '%jet%' HAVING jcc_users.banned_id = 0

Is the query, tried removing the if statement altogether, still same results unfortunatley.


Messages In This Thread
MySQL query trouble - by El Forum - 09-07-2008, 09:15 PM
MySQL query trouble - by El Forum - 09-07-2008, 11:46 PM
MySQL query trouble - by El Forum - 09-08-2008, 12:09 AM
MySQL query trouble - by El Forum - 09-08-2008, 02:18 AM
MySQL query trouble - by El Forum - 09-08-2008, 03:36 AM
MySQL query trouble - by El Forum - 09-08-2008, 02:54 PM
MySQL query trouble - by El Forum - 09-13-2008, 11:20 PM
MySQL query trouble - by El Forum - 09-14-2008, 02:35 AM



Theme © iAndrew 2016 - Forum software by © MyBB