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";
}
?>