DB is mysql.
I have the below query which i'm trying to run through PHP.
$sql = "SELECT DISTINCT pid FROM campaign_details WHERE camp_id='$camp_id' LIMIT 7";
$newquery = mysql_query($sql) or die(mysql_error());
There are 10 distinct pid values but I want only 7.
The stupid thing returns all of them when I need to limit them at 7.
Any work around this?
Or Do I need to go and take a coffee break and have another look? haha.