$vehlist1 = "SELECT DISTINCT sch_id, veh_no  FROM {$table}";
$vehlist = $conn->Execute($vehlist1);
$num_columns = $vehlist->Fields->Count();

echo "<p class='innerhead'>Schedule Tracking Info..</p>";
echo "<form name='frmschinfo' method='post' action='schtracking_storedatatest1.php' onSubmit='return accept()'>";
echo "<table width='800px', border='0'><tr>";
echo "<td class='gentext' width='150px'>$vehicleid</td>";
echo "<td class='gentext' width='100px'><select id='strvehicle' name='strvehicle' onchange='Choice(); fn(this);'>";
for ($k=1; $k < $num_columns; $k++) {
    $fields[$k] = $vehlist->Fields($k);
}
echo "<option value=0> --Select -- </option>";

while($row1 = $vehlist->GetArray())
{
?>
                <option value="<?php echo $row1[veh_no];?>" title="<?php echo $row1[sch_id];?>" <?php if($row1[veh_no]==$test) echo 'selected';?>>
        <?php echo $row1[veh_no];?>      </option>

                <!--echo "<option value=\"$row1[veh_no]\" title=\"$row1[sch_id]\" >$row1[veh_no]</option>";-->

<?php
}
echo "</select></td>";
echo "<td class='gentext' width='50px'>$space</td>";
echo "<td class='gentext' width='150px'>$scheduleid</td>";
echo "<td class='gentext' width='70px'><input name='txtschid' id='txtschid' type='text' size='25' maxlength='50' value='{$test1}' readonly='readonly'/></td>";
echo "<td class='gentext' width='50px'>$space</td>";
echo "<td class='gentext' width='80px'>$date</td>";
echo "<td class='gentext' width='70px'><input name='txtdate' type='text' id='txtdate' size='20' maxlength='30' onclick='ds_sh(this);' /></td>";
echo "<td width='50px'> </td>";
echo "</tr>";
echo "<tr><td class='gentext'> </td>";
echo "<td class='gentext' width='100px'> </td>";
echo "</tr>";
echo "<tr><td colspan='5' class='redtext'>$success1</td></tr>";
echo "<tr><td> </td></tr>";
echo "</table>\n";
$vehlist->Close();
$vehlist = null;
}
else echo "ADODB not connected";