i would like to echo
some SQL data into a <select>
form with each as a different row from the table.
i have a table:-
repair (repair_id , date , machine_name ,Machine_vin , request , adresss);
and i would like to have the Machine_vin
numbers to come in the select options.. and each time one is removed or added it reflects in the option.
am stumped on code, only have:
<?php
$sql = "select * from repair";
$res = mysqli_query($conn,$sql);
$selectResult="";
while($list = mysqli_fetch_array($res)){
$Machine_vin = $list['Machine_vin'];
$selectResult.="<option value="$Machine_vin">$Machine_vin</option>";
?>
get a Parse error: syntax error, unexpected '$Machine_vin'
how do i reflect the machine_vins
in the <select>
option.