<select name="OfficeCode" id="OfficeCode" onchange="chooseSuppProc(this.value,'OffCode','capaCat','')" >
<option value="no">Choose an option</option>
<option value="no">--------</option>
<?php
$cmdProcNeg = new MySqlCommand("select DISTINCT o.off_name, o.off_code from negotiation as n, user as u, manufacturer as m, office as o where n.ngt_procur_usr_code = '".$_SESSION['uid']."' AND u.usr_email = n.ngt_buyer_usr_code AND o.off_code = u.usr_off_code" , $this->Connection);
$dreadProcNeg = $cmdProcNeg->ExecuteReader();
for($x = 0; $x < $dreadProcNeg->Count(); $x++)
{
echo "<option value=\"".$dreadProcNeg->ReadTableRow($x,"off_code")."\">".$dreadProcNeg->ReadTableRow($x,"off_name")."</option>";
}
?>
<option value="no">--------</option>
<option value="all">All</option>
</select>