$HID='PK'; include( "connectdb.php" ); include( "functions.php" ); mysql_connect($ServerName, $UserName, $UserPassword ) || UhOh("Can't Connect to Database: ".mysql_error()); mysql_select_db($DataBaseName); Conn2DB(); $query = "select * from destination3 where left(des_code,2)='$HID'"; $result = mysql_query($query); $row = mysql_fetch_array($result); $mcity = $row["destinations"]; global $cur; switch ($cur) { case "": $query = "SELECT * FROM currency where cur LIKE 'USD'"; $result = mysql_query($query); $row = mysql_fetch_array($result); $unitrate = $row["des"]; $vrates = $row["rates"]; break; default: $query = "SELECT * FROM currency where cur LIKE '$cur'"; $result = mysql_query($query); $row = mysql_fetch_array($result); $cur = $row["cur"]; $unitrate = $row["des"]; $vrates = $row["rates"]; } ?>