Mindanao Bloggers

These are the bloggers who have signified their intent
to participate in the 1st Mindanao Bloggers Summit,
to be held in Davao City this 27 October 2007 (Saturday).
Get yourself listed here »»

global $wpdb;
$cities = $wpdb->get_results(“select * from registration group by city”);

foreach ($cities as $city) {
$bloggers .= “

$city->city

“;
$results = “”;
$sql=”select * from registration where valid = 1 AND city=’$city->city’ order by lname asc”;
$results = $wpdb->get_results($sql);
if ($results) {
$bloggers .= “

“;
}
foreach ($results as $result) {
$bloggers .= ”
1. $result->lname, $result->fname”;
   $bloggers .= ”  -  blogurl\” “;
   if ($result->country == “xx”) $bloggers .= “rel=\”nofollow\” “;
   $bloggers .= “style=\”color:#008800\”>$result->blogtitle“;
   $bloggers .= “

“;
}
if ($results) {
$bloggers .= “

“;
}
}

if ($bloggers) {
echo $bloggers;
}
?>