[SOLVED] select value not being passed

[will35010]

I have two php functions that generate options for select menus. The menu displays properly, but the value isn't being passed.

 

The value is supposed to be $row['dl']

function getDrivers() {
require('opendb.php');
$result = mysqli_query($conn, "SELECT fname, lname, dl FROM drivers");

while($row = mysqli_fetch_array($result))
{
  echo "<option value=\"" . $row['dl'] . "\">".$row['lname'].",".$row['fname']."</option>";
}
}

The value is supposed to be $row1['vin']

function getVehicles() {
require('opendb.php');
$result1 = mysqli_query($conn, "SELECT vin, plate, year FROM vehicles");
while($row1 = mysqli_fetch_array($result1)) {
echo "<option value=\"" . $row1['vin'] . "\">".$row1['plate'].",".$row1['year']."</option>";
}
}

[will35010]

I fixed the second function. I had $row instead of $row1. I still can't get the first one to pass 'dl'.

[gizmola]

Where is your tags?

[will35010]

Where is your <select> </select> tags?

 

They are on the actual form. I have <?php echo getDrivers() ?> in between the tags. It works for getVehicles() and passes the value, but getDrivers() doesn't pass the value of dl.

[ldougherty]

All the escaping is killing my eyes..

 

try

 

echo "<option value='$row[dl]'>$row[lname] $row[fname]</option>";