$query = "SELECT nomer_kota, nama_kota FROM kota ORDER BY nomer_kota";
if(!$result2 = $conn->query($query)) {
echo "Error : ".mysql_error()."
"; $conn->close(); exit; } function member($mem) { $conn = new metabase_mysql_class; $query = "SELECT a_id FROM artis WHERE a_label = $mem"; if(!$a = $conn->query($query)) { echo "Error : ".mysql_error()."
"; $conn->close(); exit; } $query = "SELECT a_id FROM artis WHERE a_label2 = $mem"; if(!$b = $conn->query($query)) { echo "Error : ".mysql_error()."
"; $conn->close(); exit; } $aa = mysql_num_rows($a); $bb = mysql_num_rows($b); $cc = $aa + $bb; return $cc; } ?> for($ii = 0; $ii < $conn->NumberOfRows($result2); $ii++) { $kotaa = $conn->FetchResult($result2, $ii, "nama_kota"); $noo = $conn->FetchResult($result2, $ii, "nomer_kota"); $query = "SELECT * FROM label WHERE approved = 1 AND label_city = $noo ORDER BY label_name ASC"; if(!$labels = $conn->query($query)) { echo "Error : ".mysql_error()."
"; $conn->close(); exit; } $num_rows = mysql_num_rows($labels); if ($num_rows > 0) { ?>
"; $conn->close(); exit; } function member($mem) { $conn = new metabase_mysql_class; $query = "SELECT a_id FROM artis WHERE a_label = $mem"; if(!$a = $conn->query($query)) { echo "Error : ".mysql_error()."
"; $conn->close(); exit; } $query = "SELECT a_id FROM artis WHERE a_label2 = $mem"; if(!$b = $conn->query($query)) { echo "Error : ".mysql_error()."
"; $conn->close(); exit; } $aa = mysql_num_rows($a); $bb = mysql_num_rows($b); $cc = $aa + $bb; return $cc; } ?> for($ii = 0; $ii < $conn->NumberOfRows($result2); $ii++) { $kotaa = $conn->FetchResult($result2, $ii, "nama_kota"); $noo = $conn->FetchResult($result2, $ii, "nomer_kota"); $query = "SELECT * FROM label WHERE approved = 1 AND label_city = $noo ORDER BY label_name ASC"; if(!$labels = $conn->query($query)) { echo "Error : ".mysql_error()."
"; $conn->close(); exit; } $num_rows = mysql_num_rows($labels); if ($num_rows > 0) { ?>
-
// LABELS
for($i = 0; $i < $conn->NumberOfRows($labels); $i++) {
$Name = $conn->FetchResult($labels, $i, "label_name");
$Thumbnail = $conn->FetchResult($labels, $i, "label_logo");
$id = $conn->FetchResult($labels,$i,"id");
$url = $conn->FetchResult($labels,$i,"label_url");
$members = member($id);
echo "
- "; echo "
"; echo "
".$Name."
$members
";
if(($i+1) % 3 == 0) {
echo '';
} else {
echo '';
}
}
?>
if ($context['user']['is_guest']) { } else { ?>
REGISTER LABEL } ?>
include 'flyer.php'; ?>
include 'banner_kotak.php'; ?>
include 'fb_block.php'; ?>