where clause is ambiguous

[teddy blachard]

So I'm getting this error.

ERROR: Column 'state' in where clause is ambiguous

I know this means that I have more than one table in which the column header 'state' is used.

Here is the code snippet:

$state_select = buildStateSelect($state);
$city_select = buildCitySelect($state,$city);


function buildCitySelect($state,$city) {

if ($state) {
$qry = "select DISTINCT city from employees where state='$state' order by 'city' asc";
}
else {
$qry = "select DISTINCT city from employees order by 'city' asc";
}
$res = mysql_query($qry) or die("ERROR: ".mysql_error());
$cnt = mysql_num_rows($res);


$city_select = "<select name=\"city\" onchange=submit();>";
if (!$city) {
$cur_sel = "<option value=\"\" selected>All</option>\n";
}
else {
$cur_sel = "<option value=\"$city\" selected>$city</option>\n";
$cur_sel .= "<option value=\"\">All</option>\n";
}

$city_select .= $cur_sel;

do {
if ($emp_city) {
$city_select .= "<option value=\"$emp_city[city]\">$emp_city[0]</option>\n";
}
}while($emp_city = mysql_fetch_array($res));
$city_select .= "</select>";



return($city_select);

}


I've tried several things like employee.state or state="'$_SESSION['state']'" but nothing has worked thus far. Any suggestions?