<?php require_once('../Connections/BE2.php'); ?>
<?php
$colname_Rt1 = "-1";
if (isset($_POST['cid'])) {
  $colname_Rt1 = (get_magic_quotes_gpc()) ? $_POST['cid'] : addslashes($_POST['cid']);
}

mysql_select_db($database_BE2, $BE2);
$query_Rt1 = sprintf("SELECT distinct(z3),z0 FROM zip2 WHERE cid = '%s' order by z3", $colname_Rt1);
$Rt1 = mysql_query($query_Rt1, $BE2) or die(mysql_error());
$row_Rt1 = mysql_fetch_assoc($Rt1);
$totalRows_Rt1 = mysql_num_rows($Rt1);
?>
 <option value="0" selected="selected">=====</option>
  <?php do {  ?>
  <option value="<?php echo $row_Rt1['z0']?>"><?php echo $row_Rt1['z3']?></option>
  <?php
  } while ($row_Rt1 = mysql_fetch_assoc($Rt1));
mysql_free_result($Rt1);
?>
