[SOLVED] Function/Echo Help

[will35010]

I have this function that creates options for a select menu. I have data for it to retrieve but it doesn't work. I know it's probably something simple, but I can't find the problem.

 

function getVehicles()
{
$sql1 = "SELECT vin, plate, year FROM vehicles";
$rt = mysql_query($conn, $sql1);
while($row1 = mysql_fetch_array($rt)) {
$list1 .= '<option value="' . $row1['vin'] . '">' . $row1['plate'] . ', ' . $row1['year'] . '</option>';
}	
return $list1;
}

 

Here is the html part:

 

<select name="vin" id="vin">
          <?php getVehicles() ?>
            </select>

I've also tried

<select name="vin" id="vin">
          <?php echo getVehicles() ?>
            </select>

 

Thanks!

[Alex]

function getVehicles()
{
$sql1 = "SELECT vin, plate, year FROM vehicles";
$rt = mysql_query($sql1);
while($row1 = mysql_fetch_array($rt)) {
$list1 .= '<option value="' . $row1['vin'] . '">' . $row1['plate'] . ', ' . $row1['year'] . '</option>';
}	
return $list1;
}

<?php echo getVehicles(); ?>

[will35010]

Thanks!