Something like WHERE UNIQUE?

[Anon]

Is there a php query arguement that is like "SELECT * FROM 'tablename' WHERE 'name' UNIQUE"

goto www.phoenixbarn.34sp.com/benjobee/fiti.php and click on the 'click here to show stuff" text, want I want is for only the two unique crews to be shown, in this case 'blueprint' and 'crewless' how would I go about it?

Here is my current code:
$query = "SELECT * FROM benjobee_graffiti ORDER BY 'crew' DESC";
$result = mysql_query($query);
while($row = mysql_fetch_array($result,1))
{ echo "<a href=\"crew.php?crew=" . $row['crew'] . "\">" . $row['crew'] . "</a><br>"; }

[mega_hurtz]

use

[distinct] or [distinctrow]

in your select statement

eg. select distinct from table where condition

[bfranco]

check if

$query = "SELECT DISTINCT * FROM benjobee_graffiti ORDER BY 'crew' DESC";

is what you're looking for.

[Anon]

Fantastic! Thanks a lot guys!