<?php
$exList = "select * from $exerciseTable";
if($stmt = $conn->prepare($exList))
{
$stmt->execute();
$stmt->bind_result($id,$name);
while ($stmt->fetch())
{
echo "<option value=$id>$name</option>";
}
}
?>
I'm trying to make a dropdown list that pulls values from a mySql table that can be added to in another location. When I add values to the list it increases the number of options for the drop down menu, However no text is displayed it is just empty slots.