How to Output MySql rows in Drop Down Menu

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!

It's just keep on saying Parse error: syntax error, unexpected '' (T_ENCAPSED_AND_WHITESPACE), expecting identifier (T_STRING) or variable (T_VARIABLE) or number (T_NUM_STRING) in — ajbee
– ajbee, Commented May 14, 2014 at 7:12
one of problem is in here: ` $dateOptions = "" . "<select class='filter'>" . "<option value='{$row['date']}'>{$row['date']}</option>" . "</select>";` — Sina R.
– Sina R., Commented May 14, 2014 at 7:13

AMDG · Accepted Answer · 2014-05-14 07:15:46Z

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;
                       ?>

answered May 14, 2014 at 7:15

AMDG

9751 gold badge9 silver badges27 bronze badges

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

1 Comment

Sina R. Over a year ago

@tomjerry - Hi newuser you should accept the correct answer. You should click on ckeck mark onleft side of each question.

GluePear · Accepted Answer · 2014-05-14 07:14:16Z

0

This should work:

echo "<select class='filter'>";
while($row = mysql_fetch_assoc($reservation_date)){
    echo "<option value='".$row['date']."'>".$row['date']."</option>";
}
echo "</select>";

You need to have your select tag outside of the loop. You also had a bunch of syntax errors in your PHP.

answered May 14, 2014 at 7:14

GluePear

7,77321 gold badges73 silver badges127 bronze badges

Comments

shyammakwana.me · Accepted Answer · 2014-05-14 07:29:21Z

0

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

may this code will work for you.

answered May 14, 2014 at 7:29

shyammakwana.me

5,7624 gold badges33 silver badges53 bronze badges

Collectives™ on Stack Overflow

How to Output MySql rows in Drop Down Menu

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related