select-php How to read the drop-down menu to select data

selectphp drop-down menu

$con = mysqli_connect($db_hostname,$db_username,$db_password,$db_database);if (!$con) die("Unable to connect to MySQL: ".mysqli_connect_error());$query = "select * from tutorials";$result = mysqli_query($con,$query);$result || die("Database access failed: ".mysqli_error($con));$rows = mysqli_num_rows($result);while ($row = mysqli_fetch_assoc($result)) {    echo "Day: ", $row["day"],"
\n";    echo "Time: ", $row["time1"],"
\n";    echo "Available: ", $row["available2"],"
\n";    echo "Time: ", $row["time2"],"
\n";    echo "Available: ",$row["available"],"

\n";}

?>

Choose a day from above timetable:

Select a day
$query = "Select Day from Tutorials";
$result = Mysqli_query ($con, $query);
$result | | Die ("Database Access failed:". Mysqli_error ($con));
while ($rows = Mysqli_fetch_assoc ($result)) {
?>

Please choose one time:

Select a Time
if (Isset ($_post[' submit '))
$day = $_post[' selectday ');
echo "The day is $day";
$query = "Select time1 from Tutorials where day= ' $day '";
$result = Mysqli_query ($con, $query);
$result | | Die ("Database Access failed:". Mysqli_error ($con));
?>

