I want to make the default value the same as set in the database. This is because i am using it to edit items in the databse and want the values to be preset.
This is currently setting it to black at the start.
$_SESSION["menuID"] = $_POST["menuID"];
$menuID = $_POST["menuID"];
$menu_sql = "SELECT * FROM menu WHERE menuID = $menuID";
$menu_query = mysqli_query($dbconnect, $menu_sql);
$menu_aa = mysqli_fetch_assoc($menu_query);
$select_sql = "SELECT * FROM course ORDER BY courseID";
$select_query = mysqli_query($dbconnect, $select_sql);
$select_aa = mysqli_fetch_assoc($select_query);
<select name="courseID">
<?php do { ?>
<option selected="<?php echo $select_aa['courseID']; ?>" value="<?php echo $select_aa['courseID']; ?>"><?php echo $select_aa['name']; ?></option>
<?php } while ($select_aa = mysqli_fetch_assoc($select_query)); ?>
</select>
Setting default using ternary operator.
<select name="courseID">
<?php do { ?>
<option selected="<?php echo ( $select_aa['courseID'] == 'Your default value here' ? "selected" : "" ); ?>" value="<?php echo $select_aa['courseID']; ?>"><?php echo $select_aa['name']; ?></option>
<?php } while ($select_aa = mysqli_fetch_assoc($select_query)); ?>
</select>