All pastes #495171 Raw Edit

Untitled

public text v1 · immutable
·published 2007-05-18 16:38 UTC
rendered paste body
		<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>