liamloveslearning Posted July 4, 2011 Share Posted July 4, 2011 Hi all, i keep receiving error in my mysql syntax for the following query... $Interest1 = "soccer"; $Interest2 = "tenni"; $Interest3 = "footy"; $intres = mysql_query("select * from produgg_users, user_interests where produgg_users.twitterUser != '' and produgg_users.active !='' and produgg_users.credits >= coff and (user_interests.interest = $interest1 OR user_interests.interest = $interest2 OR user_interests.interest = $Interest3) and produgg_users.id IN (select concat_ws(',', id) from produgg_users where credits > 0 and id != ".$usersClass->userID().") and produgg_users.id NOT IN (select concat_ws(',', followedID) from produgg_activity where followerID = '".$usersClass->userID()."') and produgg_users.id NOT IN (select concat_ws(',', userid) from produgg_featured) ORDER BY coff DESC LIMIT 30;") or die(mysql_error()); I've been playing with it for the past 30 mins and cant seem to get it to work, can anybody see obvious errors? Thanks Quote Link to comment https://forums.phpfreaks.com/topic/241088-mysql-query-erroring/ Share on other sites More sharing options...
btherl Posted July 5, 2011 Share Posted July 5, 2011 What error is reported? Quote Link to comment https://forums.phpfreaks.com/topic/241088-mysql-query-erroring/#findComment-1238405 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.