Hi Guys, If i have the following code how can i SELECT CatID and not have it affected by the DISTINCT statement? Any ideas, maccam
$result = mysql_query("SELECT DISTINCT suburb FROM $table WHERE LEFT(suburb,1) = '$alphabet' ORDER BY suburb",$db);
It sounds like you want to do a seperate query.
