$result = mysql_query("select distinct country from search");


----- Original Message -----
From: "Chris Payne" <[EMAIL PROTECTED]>
Sent: Wednesday, January 16, 2002 1:29 PM
Subject: [PHP-DB] Unique Results?

Hi there everyone,

(Sorry if you got this twice, I don't think my mail server posted it

I use the following code to populate a dropdown box from a MySQL database:

$db = mysql_connect("localhost","^^^","^^^");
$result = mysql_query("select country from search");

if ($result)
   echo "<SELECT NAME='country'>";
   while ($myrow = mysql_fetch_array($result))
      echo "<OPTION VALUE=\"".$myrow["country"]."\">".
           $myrow["country"]." </OPTION> ";
   echo "</SELECT>";

However, this database has multiple country names the same (Aswell as unique
ones) how can I display just ONE of each entry?  IE: say there are 5 africa,
3 britain etc ..... I only want the list to show 1 of each and not 5 and 3
and so on - how is this possible?  Please help :-)

And thank you to everyone who helped me with an earlier enquiry, it's very
appreciated :-)

Chris Payne

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to