what command do I use for ...

[ejwf]

I have an array where the same item is listed more than once, how do I get it to list the items in an array without repeating

example
the query

$query = "SELECT CoName FROM tblClient, tblSection, tblDateLog 
 WHERE tblClient.ConcesRef = tblSection.ConcesRef AND tblDateLog.DateLogId = $DateLogId AND tblClient.ConcesRef = '".$ref."'";
 $result4 = mysql_query($query) or die(mysql_error());
 while($row4 = mysql_fetch_array($result4))
 $ClientName[] = $row4["CoName"];

gives the output
Client Name = Array ( [0] => yellow submarine ltd [1] => yellow submarine ltd [2] => yellow submarine ltd [3] => Rubber Soles [4] => Rubber Soles [5] => Rubber Soles )

how do I stop it from showing the same item more than once? is it a LIMIT thing?

[Weedpacket]

Select
The ALL, DISTINCT, and DISTINCTROW options specify whether duplicate rows should be returned. If none of these options are given, the default is ALL (all matching rows are returned). DISTINCT and DISTINCTROW are synonyms and specify that duplicate rows in the result set should be removed.