Urgent help needed with advanced query structure!
Posted: Thu Apr 17, 2008 12:17 pm
Hello,
I have this query
The SELECT query selects "id","cost" and "url". Well, that "id" is what I needed to be placed into XXXXXX in the query. How would I achieve this?
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);");