SQL Distinct Question

[micmac]

Hi Guys,
If i have the following code how can i SELECT CatID and not have it affected by the DISTINCT statement?
Any ideas,
micmac

$result = mysql_query("SELECT DISTINCT suburb FROM $table WHERE LEFT(suburb,1) = '$alphabet' ORDER BY suburb",$db);

[Musicman]

Hi,

still working on that business directory?
You should perhaps provide a little more info.
If I recall your project correctly, you had a table that describes businesses via the catId (e.g. 3 is car rentals)
Do you want to select all those suburbs where a particular kind of business is available with your query? Do you have the suburb added to the main table, or do you have a separate suburbs table that is accessed via an ID

Musicman

[micmac]

I got it soughted, i ended up doing another query.
Thanks anyway