populate drop down list from mysql database and don't repeat values

Question

I am populating a drop down menu from mysql database. It works well, But I want it not to repeat values. (i.e if some value is N times in database it comes only once in the drop down list)

Here is my code:

<?php

mysql_connect('host', 'user', 'pass');
mysql_select_db ("database");

$sql = "SELECT year FROM data";
$result = mysql_query($sql);

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

?>

sorry this is a better link stackoverflow.com/questions/2476307/… — Nicholas King
– Nicholas King, Commented Jul 16, 2012 at 9:37
"Quick Quick please" is not a very nice way to ask volunteers for help. — Ariel
– Ariel, Commented Jul 16, 2012 at 9:37

Rikesh · Accepted Answer · 2012-07-16 09:37:07Z

10

Use DISTINCT in your query.

"SELECT DISTINCT year FROM data";

answered Jul 16, 2012 at 9:37

Rikesh

26.5k14 gold badges82 silver badges90 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user1423506 · Accepted Answer · 2012-07-16 09:37:59Z

4

just change Your query. is better

$sql = "SELECT distinct year FROM data";

answered Jul 16, 2012 at 9:37

user1423506

Comments

Wouter Dorgelo · Accepted Answer · 2012-07-16 14:12:16Z

2

Another technique:

select year from table group by year

edited Jul 16, 2012 at 14:12

Wouter Dorgelo

12.1k12 gold badges67 silver badges80 bronze badges

answered Jul 16, 2012 at 9:39

Madhivanan

13.7k1 gold badge28 silver badges30 bronze badges

Comments

Gntem · Accepted Answer · 2012-07-16 09:40:12Z

1

in PHP side you have to do this

$all_data = array();

echo "<select name='year'>";
while ($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
 array_push($all_data,$row["column"]);
}
$all_data = array_unique($all_data);
foreach($all_data as $columns => $values){
 print("<option value='$value'>$value</option>");
}
echo "</select>";

answered Jul 16, 2012 at 9:40

Gntem

7,2052 gold badges37 silver badges48 bronze badges

Comments

mahadi_mohammad · Accepted Answer · 2017-02-06 22:08:02Z

1

Here is a simple trick. Take a boolean array. Which value has not come in list print it in list and which value has come in list already once, set it as true through indexing the boolean array.

Set a condition, if boolean_array[ value ] is not true, then show value in list. Otherwise, don't.

mysql_connect('host', 'user', 'pass');
mysql_select_db ("database");

$sql = "SELECT year FROM data";
$result = mysql_query($sql);

echo "<select name='year'>";
while ($row = mysql_fetch_array($result)) {

    if($bul[$row['year']] != true){
        echo "<option value='" . $row['year'] . "'>" . $row['year'] . "        </option>";
        $bul[$row['year']] = true;
   }
}
echo "</select>";
?>

answered Feb 6, 2017 at 22:08

mahadi_mohammad

1611 silver badge11 bronze badges

Collectives™ on Stack Overflow

populate drop down list from mysql database and don't repeat values

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related