DISTINCT

[Anon]

Hi all,
Why wont this line on code work?
I\'m using the DISTINCT statement to get the suburb value(s)

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

Any suggestions?
maccam

[crusty_php]

You can't have distinct everything
DISTINCT * , select the column names:
Select distinct name, phonenumber from....

[Anon]

Ok, so what if i am only want to get the DISTINCT suburb from the following query?
(not the CatID)

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

[crusty_php]

maccam wrote:

Ok, so what if i am only want to get the DISTINCT suburb from the following query?

(not the CatID)

You just ask for Distinct suburb...

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