Php mysql prevent dropdown duplicates

Question

I would like to prevent drop-down option duplicate in my edit page..

This is my query:

$res= mysql_query ("SELECT * FROM Acc_skills
INNER JOIN Accounts ON 
Accounts.Role_ID = Acc_skills.FK_Role_ID 
INNER JOIN Skills ON 
Skills.Skills_id = Acc_skills.FK_Skills_ID
WHERE Acc_skills.Acc_skills_id = '$id'");
$row = mysql_fetch_array($res);

Here is my code:

<?php 
echo '<option value= '.$row[3].' selected="selected">'.$row[3].' </option>';
echo '<option id="Low" value="Low">Low</option>
      <option id="Average" value="Average">Average</option>
      <option value="High">High</option>
</select>';
?>

I have managed to pull out the skill level data from my database (Eg, High), however, it shows duplicate drop down option now (Eg, there are 2 "High" options now). As the skill level option is manually typed in, how do i prevent having duplicate drop down options?

Thanks in advance!

The value of $row[3] is the skill level of the current record selected from the database, it can be high, average or low depending on the database record — coding18
– coding18, Commented Jan 26, 2016 at 5:54
and than u want to use selected="" according the database value right? — devpro
– devpro, Commented Jan 26, 2016 at 6:11

devpro · Accepted Answer · 2016-01-26 06:36:47Z

2

As per your comments, you need to use selected="" option as per database value. you can use like that:

<select>
<option <?=($row[3] == 'Low' ? 'selected=""' : '')?> id="Low" value="Low">Low</option>
<option <?=($row[3] == 'Average' ? 'selected=""' : '')?> id="Average" value="Average">Average</option>
<option <?=($row[3] == 'High' ? 'selected=""' : '')?> value="High">High</option>
</select>

Explanation:

If $row[3] is equal to "Average" or "High" or "Low" than select related option menu and add selected="" attribute in <option> tag.

Side Note:

Please use mysqli_* or PDO extensions becuase mysql_* extension is deprecated and not available in PHP 7.

answered Jan 26, 2016 at 6:36

devpro

16.1k3 gold badges29 silver badges39 bronze badges

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

1 Comment

coding18 Over a year ago

Thank you! i got it now! Really appreciate it!

user4486345 · Accepted Answer · 2016-01-26 05:54:49Z

first of all:

1- Please travel from mysql into mysqli or PDO , i suggest PDO.

2- if duplicated data in your database use "SELECT DISTINCT" for fetching result.

3-if you have static option try like this:

<?php 
echo "<select>";
echo '<option value= '.$row[3].' selected="selected">'.$row[3].' </option>';
echo '<option id="Low" value="Low">Low</option>
      <option id="Average" value="Average">Average</option>
      <option value="High">High</option>
</select>';
?>

or if you have fetching all rows act like this:

 echo "<select>";
    echo "<option id=Low value=Low >Low</option>
          <option id=Average value=Average>Average</option>
          <option value=High>High</option>";
        foreach($result as $index){    
         echo " < optionvalue =$index[3] selected = 'selected' > $index[3]</option > ";   
       }
     echo "</select>";

Collectives™ on Stack Overflow

Php mysql prevent dropdown duplicates

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related