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 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? Link to comment https://forums.phpfreaks.com/topic/241088-mysql-query-erroring/#findComment-1238405 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.