[PHP-DB] Unique Results?

2002-01-16 Thread Chris Payne 

Hi there everyone,

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

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

$db = mysql_connect(localhost,^^^,^^^);
mysql_select_db(mydb,$db);
$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
www.planetoxygene.com

Re: [PHP-DB] Unique Results?

2002-01-16 Thread Janet Valade 

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

Janet

- Original Message -
From: Chris Payne [EMAIL PROTECTED]
To: [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
earlier).

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

$db = mysql_connect(localhost,^^^,^^^);
mysql_select_db(mydb,$db);
$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
www.planetoxygene.com



-- 
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]