<?php require_once('../Connections/BE2.php'); ?>
<?php
$colname_Rt1 = "-1";
if (isset($_POST['z'])) {
  $colname_Rt1 = (get_magic_quotes_gpc()) ? $_POST['z'] : addslashes($_POST['z']);
}
mysql_select_db($database_BE2, $BE2);
$query_Rt1 = sprintf("SELECT distinct(z2),cid FROM zip2 WHERE z1 = '%s'", $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['cid']?>"><?php echo $row_Rt1['z2']?></option>
  <?php
  } while ($row_Rt1 = mysql_fetch_assoc($Rt1));
mysql_free_result($Rt1);
?>
