Retrieve Unique Values

[ririe44]

Hey everyone...

 

I would like to be able to retrieve the unique values of a column of a mysql table to be a list of values in my html <select> code...  for example:

 

ColA

----

red

blue

green

red

 

I want it to return... red, blue, green... and make them part of my drop down menu in my form.  Can you help me?

 

 

[mikesta707]

You can use the Distinct command in MYSQL

something like

$query = "SELECT DISTINCTcolumn_name FROM tablename";

 

[fry2010]

<?php
$con = mysql_connect("localhost","name","abc123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("my_db", $con);

$result = mysql_query("SELECT * FROM table");

while($row = mysql_fetch_array($result))
  {
  echo '<option value="'.$row['color'].'">'.$row['colorname'].'</option>';
  }

mysql_close($con);
?>

[Ken2k7]

$query = "SELECT DISTINCT `ColA` FROM `tablename`";