Melbourne and Victoria Car Removals

A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z

$hostname=”localhost”;
$username=”forklift_carrepa”;
$password=”ropes111″;
$database=”forklift_carcont”;

$postcode = get_query_var(‘postcode’);

print(”

” . $postcode . “

“);

//connection to the database
$dbContentHandle = mysql_connect($hostname, $username, $password)
or die(“Unable to connect to MySQL”);

//select a database to work with
$selected = mysql_select_db($database,$dbContentHandle)
or die(“Could not select database”);

//build the query needed to lookup nearest centers/locations
$sql = “SELECT distinct location, postcode FROM ausPostcodes WHERE state = ‘VIC’ AND location LIKE ‘” . $postcode . “%’ order by location”;

$result = mysql_query($sql);
$rows = mysql_num_rows($result);

if ($rows > 0) {
while ($row = mysql_fetch_array($result)) {
$location = mb_convert_case($row{‘location’},MB_CASE_TITLE);
$postcode = $row{‘postcode’};
print(“” . $location . “
“);
}
}

//close the connection
//mysql_close($dbContentHandle);

?>