Dupicate Question

[Anon]

How do i stop duplicates from showing in a query

$login="XXX";
$pass ="XXX";
$db=mysql_pconnect("localhost",$login,$pass);
mysql_select_db("XXXX",$db);

MySQL_select_db($db_name,$db);
$sql="select * from Men_Shoes";
$result=MySQL_query($sql,$db) or die("Bad query:".mysql_error());

while($myrow=MySQL_fetch_array($result))

{
$Type=$myrow["Type"];

echo "$Type";

}
?>

[[deleted]]

SELECT DISTINCT(field) FROM Men_Shoes;