Labels & Organizers

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; } ?> 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) { ?>

    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 ''; } } ?>
close(); ?>