Single select option to multiple choice select option

[olaoyesunday]

Please, I want to convert this single select option to multiple choice select options. i,e to select more than one option in the select dropdown
<?php

                          $get_sizes = "select * from sizes";
                          $run_sizes = mysqli_query($con,$get_sizes);
                          
                          while ($row_sizes=mysqli_fetch_array($run_sizes)){
                              
                              $size_id = $row_sizes['size_id'];
                              $size_name = $row_sizes['size'];
                              
                              echo "
                              
                              <option value='$size_id'> $size_name </option>
                              
                              ";
                              
                          }
                          
                          ?>
                          
                      </select><!-- form-control Finish -->

[Larry]

Add the "multiple" property to the opening select tag: https://developer.mozilla.org/en-US/docs/Web/HTML/Element/select

[olaoyesunday]

Thanks very much sir,

I still need your help. How do I allow size_id column in product table to store more than one size_id on a single record? I tried it directly in phpmyadmin to insert more than one size_id  on the size_id column but it was given error

[Larry]

Ah, no, you can't do that. You'll need to use PHP to break the multiple selections into their single counterparts and insert each one separately. 

[olaoyesunday]

okay thanks but  I am trying to use foreach loop where I want to enter the $_Post['size'] into database but don't know how to assign the $i variable below back to the $size variable

if(isset($_POST[‘submit’])){

$size = $_POST[‘size’];

foreach ($size as $i)
{
echo ("$i<br>");
 

}
$insert_product = "insert into products (size) values (’$size’)

[Larry]

You need to execute the query from within the FOREACH as that's the only place you have access to each individual selected size.