I have this query
Code: Select all
$db -> query('SELECT id,cost,url FROM '.PREFIX."ads WHERE ((SELECT COUNT(user_id) FROM ".PREFIX."member_clicks WHERE ad_id=XXXXXX)<=clicklimit);");
Moderator: General Moderators
Code: Select all
$db -> query('SELECT id,cost,url FROM '.PREFIX."ads WHERE ((SELECT COUNT(user_id) FROM ".PREFIX."member_clicks WHERE ad_id=XXXXXX)<=clicklimit);");