Max Per

		<select name="OfficeCode" id="OfficeCode">
				 
		 <option value="no">Choose an option</option>
		 <option value="no">--------</option>
				<?php 
						 $cmdProcNeg = new MySqlCommand("
						 						select DISTINCT o.off_name as offName, o.off_code as offCode, userByer.OffibyerCode as officeByer FROM 
													(
													select byr_neg.byrcodeNeg as buyerUser, u.usr_off_code as OffibyerCode 
													FROM user as u, 
														(
														select n.ngt_code, n.ngt_buyer_usr_code as byrcodeNeg, n.ngt_procur_usr_code
														FROM negotiation as n
														WHERE n.ngt_procur_usr_code='".$uidUser."'
														)
													as byr_neg
													WHERE
													u.usr_email=byr_neg.byrcodeNeg
													) as userByer,
													office as o
												WHERE 
												o.off_code=userByer.OffibyerCode
												" , $this->Connection);
												
		$dreadProcNeg = $cmdProcNeg->ExecuteReader();
		
		for($x = 0; $x < $dreadProcNeg->Count(); $x++) 
							{
									echo "<option value=\"".$dreadProcNeg->ReadTableRow($x,"offCode")."\">".$dreadProcNeg->ReadTableRow($x,"offName")."</option>";
								}
			
				?>
				  <option value="no">--------</option>
				 <option value="all">All</option>
		
		   </select>