本文整理匯總了PHP中MYSQL_NUM_ROWS函數的典型用法代碼示例。如果您正苦於以下問題：PHP MYSQL_NUM_ROWS函數的具體用法？PHP MYSQL_NUM_ROWS怎麽用？PHP MYSQL_NUM_ROWS使用的例子？那麽, 這裏精選的函數代碼示例或許可以為您提供幫助。
在下文中一共展示了MYSQL_NUM_ROWS函數的15個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: sendLoginDetails
function sendLoginDetails($email)
{
global $sitename;
global $logo;
$query = MYSQL_QUERY("SELECT `Username`,`Password` FROM `ChallengeMembers` WHERE `Email` = '" . $email . "' ") or die(MYSQL_ERROR());
if ($query) {
if (MYSQL_NUM_ROWS($query)) {
while ($row = MYSQL_FETCH_ARRAY($query)) {
$userpassword = $row['Password'];
$username = $row['Username'];
}
/*send email*/
include 'email_class.php';
$em = new EmailTemplate();
$subject = ucfirst($sitename) . " Login Details";
$headers = "From: " . ucwords($sitename) . " <admin@domaindirectory.com> \r\n" . 'X-Mailer: PHP/' . phpversion();
$headers .= 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
$email_message = $username . ",<br /><br /> Thank you for your interest in joining our challenges.\n\t\t\t\t\t\t\t\t\t<br /><br />\n\t\t\t\t\t\t\t\t\tThe following are your login data:\n\t\t\t\t\t\t\t\t\t<br>\n\t\t\t\t\t\t\t\t\tUsername : <b>" . $username . "</b><br />\n\t\t\t\t\t\t\t\t\tPassword : <b>" . $userpassword . "</b>\n\t\t\t\t\t\t\t\t\t<br /><br />\n\t\t\t\t\t\t\t\t\tThank you.<br />\n\t\t\t\t\t\t\t\t\t<b>" . $sitename . "</b>";
$emailmessage = $em->get($logo, $sitename, $email_message);
/*first send to guest */
$sentmail = mail($email, $subject, $emailmessage, $headers);
/*end of send email*/
return "OK";
} else {
return $email . "not found in database.";
}
} else {
return "Email not found in database.";
}
}示例2: CheckIfVerified
function CheckIfVerified($code)
{
$query = MYSQL_QUERY("SELECT `ChallengeMemberId` FROM `ChallengeMembers` WHERE VerificationCode = '" . $code . "' ") or die(MYSQL_ERROR());
if (MYSQL_NUM_ROWS($query) > 0) {
while ($row = MYSQL_FETCH_ARRAY($query)) {
$member_id = $row['ChallengeMemberId'];
$result = MYSQL_QUERY("UPDATE `ChallengeMembers` SET `Verified` = '1' WHERE `ChallengeMemberId` = '" . $member_id . "' ") or die(MYSQL_ERROR());
}
return true;
} else {
return false;
}
}示例3: getSponsoredChallengesClosedCount
function getSponsoredChallengesClosedCount($challenger_id){
$query = MYSQL_QUERY("SELECT COUNT(*) AS total FROM `Challenges` WHERE `CompanyId` = '".$sponsor_id."' AND `Solved` = '1' ") OR DIE(MYSQL_ERROR());
if($query){
if(MYSQL_NUM_ROWS($query) > 0){
while($row = MYSQL_FETCH_ARRAY($query)){
$total = $row['total'];
}
return $total;
}else{
return 0;
}
}else{
return 0;
}
}示例4: lookupField
function lookupField($table, $id_field, $lookup_field, $id_value)
{
$sql_lookup = "SELECT `{$lookup_field}` from `{$table}` where `{$id_field}` = '{$id_value}'";
$result_lookup = MYSQL_QUERY($sql_lookup);
$rows_lookup = MYSQL_NUM_ROWS($result_lookup);
if ($rows_lookup == null || ($rows_lookup = 0)) {
return 0;
} else {
$filds = explode(",", $lookup_field);
$ind = 0;
$value = "";
while ($ind < count($filds)) {
$value .= stripslashes(MYSQL_RESULT($result_lookup, 0, $filds[$ind]) . " ");
$ind++;
}
return trim($value);
}
}示例5: get_tabdesc
function get_tabdesc($sectionid, $section)
{
global $flolang;
return $flolang->sprintf($flolang->tabbar_desc_usernotes, MYSQL_NUM_ROWS(MYSQL_QUERY("SELECT id FROM flobase_usernotes WHERE sectionid='" . mysql_real_escape_string($sectionid) . "' AND section = '" . mysql_real_escape_string($section) . "'")));
}示例6: MYSQL_QUERY
}
$querystring = "SELECT id FROM flobase_usernotes WHERE userid='{$userid}' {$noteslanguages}";
$querynoteslist = MYSQL_QUERY($querystring);
$amountnotes = MYSQL_NUM_ROWS($querynoteslist);
$tabbar['usernotes']['desc'] = $flolang->sprintf($flolang->contributed_tabbar_desc_usernotes, $amountnotes);
$pageselect = $florensia->pageselect($amountnotes, array("contributed", $userid, $username), array('anchor' => 'usernotes'), 10);
$querynotes = MYSQL_QUERY($querystring . " ORDER BY section, dateline DESC LIMIT " . $pageselect['pagestart'] . ",10");
while ($notes = MYSQL_FETCH_ARRAY($querynotes)) {
$noteslistcontent .= $classusernote->get_entry($notes['id']);
}
$noteslistcontent = "\n <a name='usernotes'></a>\n <div name='usernotes' class='small'>\n <div style='margin-top:10px;'>" . $pageselect['selectbar'] . "</div>\n {$noteslistcontent}\n <div style='margin-top:10px;'>" . $pageselect['selectbar'] . "</div>\n </div>\n ";
}
if ($userid == $flouser->userid or $flouser->get_permission("watch_log")) {
$querystring = "SELECT class, classid FROM flobase_addition WHERE entrystatus LIKE '%,{$userid},%'";
$flagsquery = MYSQL_QUERY($querystring);
$amountflags = MYSQL_NUM_ROWS($flagsquery);
$tabbar['flags']['desc'] = $flolang->sprintf($flolang->contributed_tabbar_desc_flags, $amountflags);
$pageselect = $florensia->pageselect($amountflags, array("contributed", $userid, $username), array('anchor' => 'flags'), 20);
$flagsquery = MYSQL_QUERY($querystring . " ORDER BY class LIMIT " . $pageselect['pagestart'] . ",20");
while ($flags = MYSQL_FETCH_ARRAY($flagsquery)) {
switch ($flags['class']) {
case "npc":
$npc = new floclass_npc($flags['classid']);
$flagscontent .= "<div class='shortinfo_" . $florensia->change() . "'>" . $npc->shortinfo() . "</div>";
break;
case "item":
$item = new floclass_item($flags['classid']);
$flagscontent .= "<div class='shortinfo_" . $florensia->change() . "'>" . $item->shortinfo() . "</div>";
break;
case "quest":
$flagscontent .= "<div class='shortinfo_" . $florensia->change() . "'>" . $classquest->get_shortinfo($flags['classid']) . "</div>";示例7: die
<?php
require_once "./init.php";
if (!defined('is_florensia')) {
die('Hacking attempt');
}
$flolang->load("droplist");
if (!$mybb->user['uid']) {
$florensia->output_page($flouser->noaccess($flolang->droplist_updateentry_error_notloggedin));
}
$flolang->load("item");
$flolang->load("npc");
###
$notyetincludedworkaround = "AND !(" . $florensia->get_columnname("attackmax", "npc") . "='0' && " . $florensia->get_columnname("attackmin", "npc") . "='0' && " . $florensia->get_columnname("level", "npc") . "='1' && " . $florensia->get_columnname("hppoints", "npc") . "='0' && " . $florensia->get_columnname("manapoints", "npc") . "='0' && " . $florensia->get_columnname("exp", "npc") . "='0')";
###
if ($_GET['itemid'] && MYSQL_NUM_ROWS(MYSQL_QUERY("SELECT itemid FROM server_item_idtable WHERE itemid='" . mysql_real_escape_string($_GET['itemid']) . "' LIMIT 1")) or $_GET['npcid'] && MYSQL_NUM_ROWS(MYSQL_QUERY("SELECT " . $florensia->get_columnname("npcid", "npc") . " FROM server_npc WHERE " . $florensia->get_columnname("npcid", "npc") . "='" . mysql_real_escape_string($_GET['npcid']) . "' LIMIT 1"))) {
if (strlen($_GET['search']) == 0) {
if ($_GET['itemid']) {
header("Location: " . $florensia->outlink(array("itemdetails", $_GET['itemid'], $stringtable->get_string($_GET['itemid'])), array(), array("escape" => FALSE)));
} else {
header("Location: " . $florensia->outlink(array("npcdetails", $_GET['npcid'], $stringtable->get_string($_GET['npcid'])), array(), array("escape" => FALSE)));
}
}
if ($_GET['itemid']) {
$item = new floclass_item($_GET['itemid']);
$addtoentry = $item->shortinfo();
foreach (explode(" ", $_GET['search']) as $keyword) {
$searchstring[] = "name_{$stringtable->language} LIKE '%" . get_searchstring($keyword, 0) . "%'";
}
$querystring = "SELECT " . $florensia->get_columnname("npcid", "npc") . " FROM server_npc WHERE " . join(" AND ", $searchstring) . " {$notyetincludedworkaround} AND npc_file='MonsterChar' ORDER BY name_{$stringtable->language}";
$formlink = $florensia->outlink(array("itemdetails", $_GET['itemid'], $stringtable->get_string($_GET['itemid'])), array(), array("anchor" => "droplist"));示例8: die
require_once "./init.php";
if (!defined('is_florensia')) {
die('Hacking attempt');
}
$florensia->sitetitle("CharacterAPI");
$flolang->load("character");
if (strlen($_GET['verify'])) {
if (!$flouser->userid) {
$verificationbar = "<span style='color:#FF0000'>{$flolang->character_api_verify_error_notloggedin}</span>";
} else {
$character = new class_character($_GET['verify']);
if (!$character->is_valid()) {
$verificationbar = "<span style='color:#FF0000'>" . $character->get_errormsg() . "</span>";
} elseif ($character->data['ownerid']) {
$verificationbar = $flolang->character_api_already_verified;
} elseif (MYSQL_NUM_ROWS(MYSQL_QUERY("SELECT id FROM flobase_character_verification WHERE userid='{$flouser->userid}' AND characterid='{$character->data['characterid']}' AND accepted='-1'"))) {
$verificationbar = $flolang->character_api_verify_pending;
} else {
if ($_POST['do_upload'] && $_FILES['screenshot']['tmp_name']) {
//verify if the screen is the original one.
$screen = fopen($_FILES['screenshot']['tmp_name'], "rb");
$header = fread($screen, 163);
$origheader = "ÿØÿàJFIFÿÛC\t\t\n\f\r\f\v\v\f \$.' \",#(7),01444'9=82<.342ÿÛC\t\t\t\f\v\f\r\r2!!22222222222222222222222222222222222222222222222222ÿÀ";
if ($header == $origheader) {
MYSQL_QUERY("INSERT INTO flobase_character_verification (userid, characterid, timestamp) VALUES('{$flouser->userid}', '{$character->data['characterid']}', '" . date("U") . "')");
@rename($_FILES['screenshot']['tmp_name'], "{$florensia->root_abs}/pictures/characterverification/" . mysql_insert_id());
chmod("{$florensia->root_abs}/pictures/characterverification/" . mysql_insert_id(), 0755);
$verificationbar = $flolang->character_api_verify_pending;
$florensia->notice($flolang->character_api_verify_upload_successfully, "successful");
$flolog->add("character:verification:request", "{user:{$flouser->userid}} created {characterverification:" . mysql_insert_id() . "} for {characterid:{$character->data['characterid']}}");
} else {示例9: getColoumnAsArray
function getColoumnAsArray($table, $coloumn1, $coloumn2)
{
if ($coloumn2) {
$sql = "SELECT {$coloumn1},{$coloumn2} FROM {$table}";
$result = MYSQL_QUERY($sql);
$rows_result = MYSQL_NUM_ROWS($result);
checkError($result, $sql);
$arra = array();
$i = 0;
while ($i < $rows_result) {
$j = MYSQL_RESULT($result, $i, $coloumn2);
$arra[$j] = MYSQL_RESULT($result, $i, $coloumn1);
$i++;
}
} else {
$sql = "SELECT {$coloumn1} FROM {$table}";
$result = MYSQL_QUERY($sql);
$rows_result = MYSQL_NUM_ROWS($result);
checkError($result, $sql);
$arra = array();
$i = 0;
while ($i < $rows_result) {
$arra[$i] = MYSQL_RESULT($result, $i, $coloumn1);
$i++;
}
}
return $arra;
}示例10: unset
$marketsitetitle = "<div style='margin-bottom:5px;' class='subtitle'><a href='" . $florensia->outlink(array("market")) . "'>{$flolang->market_title_main}</a> > {$flolang->market_title_sell} {$serversitetitle}</div>";
}
} else {
$marketsitetitle = "<div style='margin-bottom:5px;' class='subtitle'><a href='" . $florensia->outlink(array("market")) . "'>{$flolang->market_title_main}</a> > {$flolang->market_title_all} {$serversitetitle}</div>";
unset($exchangetype, $exchangedb);
}
$selectexchangetypeform = "\n\t\t<select name='cat'>\n\t\t\t<option value='all'>{$flolang->market_title_all}</option>\n\t\t\t<option value='sell' " . $selectexchangetype['sell'] . ">{$flolang->market_title_sell}</option>\n\t\t\t<option value='buy' " . $selectexchangetype['buy'] . ">{$flolang->market_title_buy}</option>\n\t\t</select>\n\t";
if ($_GET['search']) {
foreach (explode(" ", $_GET['search']) as $keyword) {
$searchstring[] = "server_item_idtable.name_{$stringtable->language} LIKE '%" . get_searchstring($keyword, 0) . "%'";
}
$searchstring = join(" AND ", $searchstring) . " AND";
$marketsitetitle = "<div style='margin-bottom:5px;' class='subtitle'><a href='" . $florensia->outlink(array("market")) . "'>{$flolang->market_title_main}</a> > " . $flolang->sprintf($flolang->market_title_searching, $florensia->escape($_GET['search'])) . " {$serversitetitle}</div>";
}
$query = "SELECT flobase_usermarket.id as marketid, flobase_usermarket.itemid as itemid FROM server_item_idtable, flobase_usermarket WHERE {$searchstring} server_item_idtable.itemid=flobase_usermarket.itemid {$exchangedb} {$serverdb} ORDER BY flobase_usermarket.createtime DESC";
$querystringlist = MYSQL_QUERY($query);
$entries = MYSQL_NUM_ROWS($querystringlist);
$pageselect = $florensia->pageselect($entries, array("market", $exchangetype), array($serverlink));
$querystringlist = MYSQL_QUERY($query . " LIMIT " . $pageselect['pagestart'] . "," . $florensia->pageentrylimit);
while ($itemlist = MYSQL_FETCH_ARRAY($querystringlist)) {
$content .= $florensia->adsense(8);
$item = new floclass_item($itemlist['itemid']);
$content .= "<div class='shortinfo_" . $florensia->change() . "'>" . $item->shortinfo(array("marketid" => $itemlist['marketid'])) . "</div>";
}
if (!$content) {
$content = "<div style='text-align:center' class='warning'>{$flolang->market_noentries}</div>";
}
$content = "\n\t\t{$marketsitetitle}\n\t\t<div style='text-align:center; margin-bottom:5px;'>" . $florensia->quick_select('marketsearch', array('cat' => $exchangetype, 'search' => $_GET['search']), array($flolang->market_title_listitems => $selectexchangetypeform), $settings = array('namesselect' => 1, 'serverselect' => 1)) . "</div>\n\t\t<div style='margin-bottom:10px;'>" . $pageselect['selectbar'] . "</div>\n\t\t{$content}\n\t\t<div style='margin-top:10px;'>" . $pageselect['selectbar'] . "</div>\n\t";
}
$content = "<div style='text-align:center; margin-bottom:15px;''>" . $florensia->quicksearch(array('language' => true)) . "</div>\n\t\t{$content}\n\t";
$florensia->output_page($content);示例11: GereChampsDoubles
function GereChampsDoubles($id, $connexion)
{
// Mise à jour de la table adhérents quand la table adhésions est modifiée.
$requete = "SELECT * FROM adhesions WHERE ad_adherent='{$id}' AND ad_etat='1' ORDER BY ad_annee DESC ";
$resultat = ExecRequete($requete, $connexion);
$compteur = MYSQL_NUM_ROWS($resultat);
if ($compteur > 1) {
$requete3 = "UPDATE personnes SET pe_ancien='1' WHERE pe_id='{$id}'";
} else {
$requete3 = "UPDATE personnes SET pe_ancien='0' WHERE pe_id='{$id}'";
}
$resultat3 = ExecRequete($requete3, $connexion);
if ($compteur > 0) {
$objet = ObjetSuivant($resultat);
$requete2 = "UPDATE personnes SET pe_annee9='{$objet->ad_annee}' WHERE pe_id='{$id}'";
$resultat = ExecRequete($requete2, $connexion);
} else {
$objet = ObjetSuivant($resultat);
$requete2 = "UPDATE personnes SET pe_annee9='0' WHERE pe_id='{$id}'";
$resultat = ExecRequete($requete2, $connexion);
}
}示例12: MYSQL_QUERY
$querysignature = MYSQL_QUERY("SELECT template FROM flobase_signaturetemp WHERE userid='" . $signaturetemp[1] . "'");
if ($signature = MYSQL_FETCH_ARRAY($querysignature)) {
$signature['layout'] = "create/" . $signaturetemp[1];
} else {
//ungueltige id oder keine angegeben
$querysignature = MYSQL_QUERY("SELECT * FROM flobase_signature");
$signature = rand(1, MYSQL_NUM_ROWS($querysignature));
$querysignature = MYSQL_QUERY("SELECT * FROM flobase_signature LIMIT " . bcsub($signature, 1) . ",{$signature}");
$signature = MYSQL_FETCH_ARRAY($querysignature);
}
} else {
$querysignature = MYSQL_QUERY("SELECT * FROM flobase_signature WHERE id='" . $signature . "'");
if (!($signature = MYSQL_FETCH_ARRAY($querysignature))) {
//ungueltige id oder keine angegeben
$querysignature = MYSQL_QUERY("SELECT * FROM flobase_signature");
$signature = rand(1, MYSQL_NUM_ROWS($querysignature));
$querysignature = MYSQL_QUERY("SELECT * FROM flobase_signature LIMIT " . bcsub($signature, 1) . ",{$signature}");
$signature = MYSQL_FETCH_ARRAY($querysignature);
}
}
if (!($xml = simplexml_load_string($signature['template']))) {
die("Failed to load template");
}
$imagepic = $layerfolder . "/" . $signature['layout'];
$info = getimagesize($imagepic);
if ($info[2] == 2) {
//JPEG / JPG
$Teilgrafik = imagecreatefromjpeg($imagepic);
} elseif ($info[2] == 3) {
//PNG
$Teilgrafik = imagecreatefrompng($imagepic);示例13: if
# else $linkedchars = 0;
# if (strlen($image['guildlinkedlist'])) $linkedguilds = count(explode(",",$image['guildlinkedlist']));
# else $linkedguilds = 0;
$privacyaccess = $classgallery->check_privacy($image);
if (!$privacyaccess['access']) {
$thumpnail = "<img src='{$florensia->layer_rel}/gallery_locked.png' style='border:0px;' alt='{$flolang->gallery_thumbnail_noaccess}' " . popup("<div class='subtitle warning small' style='text-align:center; font-weight:normal;'>" . $flolang->sprintf($flolang->gallery_error_nopermission, join("<br />", $privacyaccess['reason'])) . "</div>", "") . ">";
} else {
$thumpnail = "<img src='{$florensia->root}/pictures/gallery/{$image['galleryid']}_thumb' style='border:0px;' alt='" . $florensia->escape($image['name']) . "'>";
}
if (strlen($image['name']) > 30) {
$imagetitle = substr($image['name'], 0, 30) . "...";
} else {
$imagetitle = $image['name'];
}
if ($image['commenting']) {
$comments = "\n <tr>\n <td style='text-align:center;'><img src='{$florensia->layer_rel}/icon_notes.gif' alt='Notes:'></td>\n <td style='vertical-align:bottom;'>" . MYSQL_NUM_ROWS(MYSQL_QUERY("SELECT id FROM flobase_usernotes WHERE sectionid='" . mysql_real_escape_string($image['galleryid']) . "' AND section = 'gallery'")) . "</td>\n </tr>\n ";
} else {
unset($comments);
}
if ($image['voting']) {
$voting = "\n <tr>\n <td style='text-align:center;'><img src='{$florensia->layer_rel}/icon_thumpsup.gif' alt='Up:'></td>\n <td style='vertical-align:bottom;'>{$image['thumpsup']}</td>\n </tr>\n <tr>\n <td style='text-align:center;'><img src='{$florensia->layer_rel}/icon_thumpsdown.gif' alt='Down:'></td>\n <td style='vertical-align:bottom;'>{$image['thumpsdown']}</td>\n </tr>\n ";
} else {
unset($voting);
}
$images .= "\n <div class='gallerylist small'>\n <div style='font-weight:bold; min-height:12px;'>" . $florensia->escape($imagetitle) . "</div>\n <div class='thumbnail' style='float:left;'>\n <a href='" . $florensia->outlink(array("gallery", "i", $image['galleryid'], $image['name'])) . "'>\n {$thumpnail}\n </a>\n </div>\n <div>\n <table style='margin-left:{$image['twidth']}; border-spacing:1px;'>\n <tr>\n <td style='width:17px; text-align:center;'><img src='{$florensia->layer_rel}/icon_cursor.png' alt='C:' style='height:17px;'></td>\n <td style='vertical-align:bottom;'>{$image['views']}/{$image['fullviews']}</td>\n </tr>\n {$voting}\n <tr>\n <td style='text-align:center;'><img src='{$florensia->layer_rel}/icon_character.gif' alt='Chars:'></td>\n <td style='vertical-align:bottom;'>{$linkedchars}</td>\n </tr>\n <tr>\n <td style='text-align:center;'><img src='{$florensia->layer_rel}/icon_guild.gif' alt='Guilds:'></td>\n <td style='vertical-align:bottom;'>{$linkedguilds}</td>\n </tr>\n {$comments}\n </table>\n </div>\n </div>";
}
if ($images) {
$imagelist .= "\n <div style='margin-top:10px;'>" . $pageselect['selectbar'] . "</div>\n {$images}\n <div style='margin-top:10px;'>" . $pageselect['selectbar'] . "</div>\n ";
}
}
unset($serverselect);示例14: MYSQL_QUERY
}
$sqlQuery4rest .= $append;
if ($_SESSION['s']['sortBy'] == "") {
$_SESSION['s']['sortBy'] = "rating";
}
if ($_SESSION['s']['sortOrder'] == $_SESSION['s']['sortBy'] and $_SESSION['s']['equal'] == 1) {
$newSortOrder = $_SESSION['s']['sortBy'];
$sqlQuery4rest .= " order by {$newSortOrder}";
$_SESSION['s']['equal'] = 0;
} else {
$newSortOrder = $_SESSION['s']['sortBy'];
$sqlQuery4rest .= " order by {$newSortOrder} desc ";
$sortEqual = 1;
}
$result4rest = MYSQL_QUERY($sqlQuery4rest);
$numberOfRows4rest = MYSQL_NUM_ROWS($result4rest);
$i = 0;
while ($i < $numberOfRows4rest) {
$menu[$i]['id'] = MYSQL_RESULT($result4rest, $i, "id");
$menu[$i]['name'] = MYSQL_RESULT($result4rest, $i, "name");
$menu[$i]['rating'] = MYSQL_RESULT($result4rest, $i, "rating");
$i++;
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<script src="../jquery/jquery.js"></script>
示例15: MYSQL_QUERY
<?php
include 'header.php';
include 'db_connect.php';
echo '<h1>Stats</h1>';
echo "<h2>Number of Users</h2><br>";
$statement = "SELECT * FROM users";
$query = MYSQL_QUERY($statement);
echo MYSQL_NUM_ROWS($query);
echo "<br><h2>Number of Organizations></h2><br>";
$statement = "SELECT * FROM organization";
$query = MYSQL_QUERY($statement);
echo MYSQL_NUM_ROWS($query);
echo "<br><h2>Number of Ratings></h2><br>";
$statement = "SELECT * FROM rating";
$query = MYSQL_QUERY($statement);
echo MYSQL_NUM_ROWS($query);
echo "<br><h2>Number of Supervisor Comments></h2><br>";
$statement = "SELECT * FROM supervisor_comments";
$query = MYSQL_QUERY($statement);
echo MYSQL_NUM_ROWS($query);
echo "<br><h2>Number of Ads></h2><br>";
$statement = "SELECT * FROM advertisements";
$query = MYSQL_QUERY($statement);
echo MYSQL_NUM_ROWS($query);
include 'footer.php';
include 'db_close.php';