Nearby Accommodations
order by name |
order by location |
|
|
|
order by distance |
NAME |
LOCATION |
TYPE |
PHONE |
URL |
DISTANCE |
$bg='c0e0f1';
//$db = mysql_connect("205.212.176.135", "fren15", "16309");
//$db = mysql_connect("localhost", "fre605", "bit3me");
// $db = mysql_connect("localhost", "frenchw_fren1", "bit3me");
$db = mysql_connect("localhost", "frenchw_fren1", "bit3me");
if (!db)
{
echo "Error: could not connect to the database";
exit;
}
// mysql_select_db("fren15");
mysql_select_db("frenchw_fren1");
$order = $_GET['order'];
if($order=="location")
$query = "select * from accomodations order by location";
elseif($order=="name")
$query = "select * from accomodations order by name";
else
$query = "select * from accomodations order by distance";
$result = mysql_query($query);
$num_results = mysql_num_rows($result);
for ($i=0; $i <$num_results; $i++)
{
$row = mysql_fetch_array($result);
echo "";
echo $row["name"]." | ";
echo $row["location"]." | ";
echo $row["type"]." | ";
echo $row["phone"]." | ";
if ($row["url"])
echo "link | ";
else
echo " | ";
echo $row["distance"]." | ";
echo "
";
if($bg=="c0e0f1")
$bg="ececec";
else
$bg="c0e0f1";
}
?>
View
the locations on Google Maps
@2015 French Woods Festival, All RIghts Reserved