如何在下拉菜单中输出MySql行

Question

I am having a Problem in this code : `

                 <?php echo "Choose a date"; 
                     $reservation_date = $rm->retrieveReservation(); 
                              $data_date = array();
                              while($row_date = mysql_fetch_assoc($reservation_date)){
                                array_push($data_date, $row_date);
                                $dateOptions = ""
    .                               "<select class='filter'>"
    .                                  "<option value='<?php echo $row['date']  ; ?>'><?php echo $row['date']  ; ?></option>"
    .                               "</select>";
                                echo $dateOptions;
                              } ?>

                           ?>

I want to output Sql row values in a dropdown menu. Thanks in advance!

Answer 1

You don't have to echo the <select> in the while, you should do like that :

 <?php echo "Choose a date"; 
                 $reservation_date = $rm->retrieveReservation(); 
                          $data_date = array();
                          $dateOptions = "<select class='filter'>";
                          while($row = mysql_fetch_assoc($reservation_date)){
                            array_push($data_date, $row_date);
                            $dateOptions = "<option value='". $row['date']."'>". $row['date'] ."</option>";
                          } ?>
                          $dateOptions = "</select>";
                          echo $dateOptions;
                       ?>