| Rather than spend money on hotels, hostels or backpacker accommodation, take advantage of GlobalFreeloaders hospitality by staying with a fellow member for free! Not only do you get to save money - you also get to see from a local's perspective! |
0) {
$city_id = intval($city_id);
$result = mysql_query("SELECT COUNT(*) FROM users WHERE city_id = $city_id");
list($numrows) = mysql_fetch_row($result);
if ($numrows > 0) {
echo "All these GlobalFreeloaders members are in $city_name and may be available to host you while you're in the area. All you need to do is sign up to GlobalFreeloaders.com, and you could be arranging your stay in $city_name with them in minutes!
|
";
}
query_table("SELECT description AS \"Meet people prepared to show you the best of $city_name!\" FROM users WHERE city_id = $city_id ORDER BY disabled, expired, LENGTH(description) DESC LIMIT 10");
} elseif ($province_id != '') {
$result = mysql_query("SELECT city.city_id, province.province_id, province.province_name, city_name, COUNT(*) FROM users, city, province WHERE users.city_id = city.city_id AND city.province_id = province.province_id AND city.country_id = province.country_id AND city.country_id = '".dbescape($country_id)."' AND city.province_id = '".dbescape($province_id)."' GROUP BY 1,2,3,4 ORDER BY 4");
while(list($cid, $pid, $pname, $cname, $count) = mysql_fetch_row($result)) {
$rows[] = array("city" => ''.$cname.'', "members" => $count);
}
$keys = array("city" => "City", "members" => "Members");
array_table($keys, $rows);
} elseif ($country != '') {
$result = mysql_query("SELECT users.city_id, city_name, province_id, COUNT(*) FROM users, city WHERE users.city_id = city.city_id AND country_id = '".dbescape($country_id)."' GROUP BY 1, 2, 3 ORDER BY 2");
while(list($cid, $cname, $pid, $count) = mysql_fetch_row($result)) {
$provres = mysql_query("SELECT province_name FROM province WHERE province_id = '".dbescape($province_id)."' AND country_id = '".dbescape($country_id)."'");
if (mysql_num_rows($provres) == 1) {
list($pname) = mysql_fetch_row($provres);
} else { $pname = ''; }
$rows[] = array("city" => ''.$cname.'', "members" => $count);
}
/*
$result = mysql_query("SELECT city.city_id, province.province_id, province.province_name, city_name, COUNT(*) FROM users, city, province WHERE users.city_id = city.city_id AND city.province_id = province.province_id AND city.country_id = province.country_id AND city.country_id = '$country_id' GROUP BY 1,2,3,4 ORDER BY 4");
while(list($cid, $pid, $pname, $cname, $count) = mysql_fetch_row($result)) {
$rows[] = array("city" => ''.$cname.'', "members" => $count);
}
*/
$keys = array("city" => "City", "members" => "Members");
array_table($keys, $rows);
} elseif (strlen($country_id) == 0) {
if ($session != '') { $sessioncode = '&session='.$session; }
$result = mysql_query("SELECT country.country_id, country_name, COUNT(*) FROM users, city, country WHERE users.city_id = city.city_id AND city.country_id = country.country_id GROUP BY 1,2 ORDER BY 2");
while(list($cid, $cname, $count) = mysql_fetch_row($result)) {
$rows[] = array("country" => ''.$cname.'', "members" => $count);
}
$keys = array("country" => "Country", "members" => "Members");
array_table($keys, $rows);
//$sqlqry = "SELECT CONCAT(\"\", country_name, \"\") AS \"Country\", COUNT(*) AS \"Members\" FROM users,city,country WHERE users.city_id=city.city_id AND city.country_id=country.country_id GROUP BY 1";
//query_table($sqlqry." ORDER BY country_name");
}
/* elseif (count($city_id_list) > 0) {
query_table("SELECT description AS \"Accommodation Information in $city_name\" FROM users WHERE city_id IN ( ".join(',', $city_id_list).") ORDER BY disabled, expired, RAND() LIMIT 10");
} elseif ($city_id > 0) {
// do nothing
query_table("SELECT description AS \"Accommodation Information in $city_name\" FROM users WHERE city_id = $city_id ORDER BY disabled, expired, RAND() LIMIT 10");
} else {
// "SELECT CONCAT(\"\", city_name, \"\") AS \"City\"
$sqlqry = "SELECT CONCAT(\"\", city_name, \"\") AS \"City\", COUNT(*) AS \"Members\" FROM users,city,province,country WHERE city.province_id = province.province_id AND province.country_id = country.country_id AND users.city_id=city.city_id AND city.country_id = province.country_id AND country.country_id='$country_id' $provsql GROUP BY 1";
//$sqlqry = "SELECT CONCAT(LOWER(REPLACE(country_name, \" \", \"_\")), \"/\", LOWER(REPLACE(province_name, \" \", \"_\")), \"/\", LOWER(REPLACE(city_name, \" \", \"_\"))) AS \"City\", COUNT(*) AS \"Members\" FROM users,city,province,country WHERE city.province_id = province.province_id AND province.country_id = country.country_id AND users.city_id=city.city_id AND city.country_id = province.country_id AND country.country_id='$country_id' $provsql GROUP BY 1";
//echo "$sqlqry
";
query_table($sqlqry." ORDER BY city_name");
}
*/
?>
|
';
echo 'View all countries
';
if ($province_id != '') {
echo 'All cities in '.ucwords(strtolower($country_name)).'
';
}
if ($city_id != '' && $province_name != '') {
echo 'All cities in '.ucwords(strtolower($province_name)).'
';
}
echo '
';
$result = mysql_query($qry = "SELECT province.province_id, province_name, COUNT(*) FROM users, city, province WHERE users.city_id = city.city_id AND city.province_id = province.province_id AND city.country_id = province.country_id AND province.country_id = '$country_id' GROUP BY 1, 2 ORDER BY 2");
while(list($provid, $provname, $count) = mysql_fetch_row($result)) {
if ($provid == $province_id) {
echo ucwords(strtolower($provname))."
";
} else {
echo ''.ucwords(strtolower($provname)).'
';
}
}
/*
if ($city_id == 0) {
echo "
The Top Five
";
query_table($sqlqry." ORDER BY 2 DESC LIMIT 5", 1, 0, "left");
echo " ";
}
*/
$rows = array();
$result = mysql_query("SELECT users.city_id, city_name, province_id, COUNT(*) FROM users, city WHERE users.city_id = city.city_id AND country_id = '$country_id' GROUP BY 1, 2, 3 ORDER BY 4 DESC LIMIT 5");
while(list($cid, $cname, $pid, $count) = mysql_fetch_row($result)) {
$rows[] = array("city" => ''.$cname.'', "members" => $count);
}
$keys = array("city" => "City", "members" => "Members");
echo "
Top Five in ".$country_name."
";
array_table($keys, $rows, 1, 0, "left");
?>
|