function showOptions($sql)
{
    $service = new BaseService();
    $results = $service->GetRows($sql);
    $id = 0;
    $i = 0;
    foreach ($results as $row) {
        if ($i == 0) {
            $id = $row[0];
        }
        echo "<option value='" . $row[0] . "'>" . $row[1] . "</option>";
        $i++;
    }
    return $id;
}