<div class="col-md-4 col-sm-4">
              <label>Date</label>
              <input type="date" class="form-control" id="dob" name="dob" placeholder="dob">
            </div>

            <div class="col-md-4 col-sm-4">
              <label>Request</label>
              <select class="form-control" name="request" id="request">
                <option value="Choose Request" id="choose_request" selected>Choose Request</option>
                <?php
                $dbhost = #############;
                $dbuser =  #############;
                $dbpass =  #############;
                $dbdata =  #############;;
                $conn = mysql_connect($dbhost, $dbuser, $dbpass);

                if ($conn->connect_error) {
                die("Connection failed: " . $conn->connect_error);
              }


              $sql = "SELECT id, client, LOWER(TIME_FORMAT(time, '%l:%i%p')) as time FROM request WHERE date = #####SOMETHING########  ORDER BY time";
              mysql_select_db('i494f17_team29');
              $result = mysql_query($sql, $conn);

              if (mysql_num_rows($result) > 0) {
                while ($row = mysql_fetch_assoc($result)) {
                    $id = $row['client'];
                    $requestId = $row['id'];

                    $date = $row['date'];
                    $time = $row['time'];

                    $sql2 = "SELECT * FROM client WHERE id='$id'";
                    mysql_select_db('i494f17_team29');
                    $result2 = mysql_query($sql2, $conn);
                    $row2 = mysql_fetch_assoc($result2);
                    $fname = $row2['fname'];
                    $lname = $row2['lname'];

                    echo "<option value='$requestId'>$fname $lname : $date $time</option>";
                }
              }