I have the following code
echo '<table class="bookings">';
while($row = mysql_fetch_array($result)){
//set variables for events
$id = $row['CourseDateID'];
$begin = $row['CourseStartDate'];
$end = $row['CourseEndDate'];
$title = $row['CourseTitle'];
$att = $row['Attendees'];
$venue = $row['CourseLocation'];
$formatted = date('Y-m-d', strtotime($begin));
echo '<tr>';
echo '<td>' . $formatted . '</td>';
echo '<td>' . $title . '</td>';
echo '<td>' . '<select>' . '<option>' . $att . '</option>' . '</select>' . '</td>';
echo ' ' . '<td>' . '<a href="/cal.php?id=' . $id . '&begin=' . $begin . '&end=' . $end . '&title=' . $title . '&att=' . $att . '&venue=' . $venue . '">Add Bookings to Calendar</a>' . '</td>';
echo '</tr>';
}
echo '</table>';
I want the <select>
to list the attendees as a dropdown but atm it creates a <select>
box with all the attendee names in rather than a dropdown list.
Hope that makes sense.