Code: Select all
$query = "SELECT res_id, start_date FROM reservations WHERE user_id=$user_id";
$error = mysqli_error($db);
echo $error;
$result = mysqli_query($db, $query);
$num_results = mysqli_num_rows($result);
echo "<p> Number of reservations found: ".$num_results."</p>";
echo "<form method='post' action='viewbill.php'>";
echo "Reservation Date: <select name = 'res_select'>";
$row=mysqli_fetch_array($result);
$res_id = $row["res_id"];
$start_date = $row["start_date"];
for ($i=0; $i < $num_results; $i++)
{
echo "<option value = '$start_date'> $start_date </option>";
}
echo "<input type='submit' value='View' />";
echo "</form>";