Implementing another list dropdown upon extra selection

Question

I have a mySQL database, and I have the option that it displays all the 'Treatments' as a dropdown box on my html page. How would I go about implementing the code, so that if the user wants to select more than one treatment, another dropdown box will appear?

EDIT: e.g. Lets say you are shopping for some items online, and you have all the items listen in a dropdown box. You pick one, and then you want to pick more. So you click: 'add more' and another dropdown appears on the page where you can select another item.

Here is the PHP code:

<?php

$hostname = 'hostname';
$dbname = 'dbname';
$username = 'username';
$password = 'password';

$con=mysql_connect($hostname,$username,$password,$dbname) or die("Failed to connect to MySQL: " . mysql_error());
$db=mysql_select_db($dbname,$con) or die("Failed to connect to MySQL: " . mysql_error());


$query = "SELECT * FROM `Treatments`";

$result = mysql_query($query, $con);
$options = "";

if (!$result){
    die("No results found.");
}

while ($row = mysql_fetch_array($result)){
    $options .= "<option>$row[1]</option>";
}


?>

*...another dropdown box will appear?* **Question Unclear** Please Elaborate. — Nana Partykar, Feb 05 '16 at 18:07
I would suggest you to have a look at available jquery plugins such as bootstrap-multiselect which will be helpful to you. — Kamal Joshi, Feb 05 '16 at 19:14
@Kamal is there any way to implement that with a mySQL database? — Filip Grebowski, Feb 05 '16 at 19:16

score 0 · Accepted Answer · edited May 23 '17 at 12:15

0

Actually you need to make multiselect drop down. If you add multiple = "multiple" HTML tag then drop down will be used as a multi select.

<select name="anyName[]" multiple>
  <?php
  while ($row = mysql_fetch_array($result)){
    echo "<option>$row[1]</option>";
 }
 ?>
</select>

For more help you will need to look this link. jQuery multiselect drop down menu

Hope It will help you.

Thanks

edited May 23 '17 at 12:15

Community

1
1

answered Feb 05 '16 at 18:11

Muhammad Rizwan Kaim Khani

2,042
3
29
37

Ahh I see thank you! I just didn't know if there is a way to approach this problem. I will try it out :) – Filip Grebowski Feb 05 '16 at 18:12
One suggestion : `name="anyName"` should be `name="anyName[]"` as selection is multiple. – Nana Partykar Feb 05 '16 at 18:13
Yes I think, now you need to try. I have edited little answer and given link. – Muhammad Rizwan Kaim Khani Feb 05 '16 at 18:17

Implementing another list dropdown upon extra selection

1 Answers1