Retrieve Names

[Dysan]

Hi,

 

I have a table that contains a list of people's first names. This table contains duplicate names.

 

Using PHP, how do I retrieve one instance of each of the names, stored in the "Names" column, and add them to a drop-down box?

[forumnz]

Do you want to retrieve specific names?

 

If so, all users should have an ID column, that way you can SELECT WHERE id='$id'

 

 

Otherwise, I dont know.

 

Good Luck!

[Psycho]

This page has a tutorial on EXACTLY what you are asking:

 

http://www.webdevelopersnotes.com/tutorials/sql/online_mysql_guide_the_distinct_keyword.php3

[Dysan]

Brillient! Cheers.

 

So I need to you the distinct clause. But, how do I put the retrieve names into a drop-down box?

[Northern Flame]

try:

 

<?php
// Connect To Database

$query = mysql_query("SELECT name FROM table");

echo "<select name=names>\n";

while($row = mysql_fetch_array($query)){
echo "<option value='". $row['name'] ."'>". $row['name'] ."</option>\n";
}

echo "</select>\n";

?>

[Dysan]

how do I change it to a list box?

[Northern Flame]

you mean like this?

 

<?php
// Connect To Database

$query = mysql_query("SELECT name FROM table");

echo "<select multiple name=names>\n";

while($row = mysql_fetch_array($query)){
echo "<option value='". $row['name'] ."'>". $row['name'] ."</option>\n";
}

echo "</select>\n";

?>