mysql_connect ($db_server, "c4mpf1r3_banaslu", "d3nv3r") or die ('I cannot connect to the database because: ' . mysql_error());
@mysql_select_db ("c4mpf1r3_directory") or die( "Unable to select database");
$state = $_GET["state"];
echo "Campgrounds in " . $state . "
";
$query = "SELECT * FROM campgrounds2 WHERE state = '$state' ORDER BY parkname";
$result = mysql_query($query) or die("could not complete your query");
if(!$result) die("Query Failed.");
while($row = @mysql_fetch_array($result)) {
$name = ucwords(strtolower($row["parkname"]));
$address = ucwords(strtolower($row["address"]));
$city = ucwords(strtolower($row["city"]));
$phone = ucwords(strtolower($row["phone"]));
$state = $row["state"];
$zip = ucwords(strtolower($row["zip"]));
echo "" . $name . " - " . $address . ", " . $city . " " . $state . " - " . $phone . "
\n";
}
?>