本文整理汇总了PHP中DB::next_record方法的典型用法代码示例。如果您正苦于以下问题:PHP DB::next_record方法的具体用法?PHP DB::next_record怎么用?PHP DB::next_record使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DB
的用法示例。
在下文中一共展示了DB::next_record方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: WriteMenu
function WriteMenu($siteid, $siteurl, $sitetarget, $a, $Display, $AdminDisplay)
{
$DbLink2 = new DB();
$DbLink2->query("SELECT id,url,target FROM " . C_PAGE_TBL . " Where parent = '" . cleanQuery($siteid) . "' and active='1' and ((display='{$Display}') or (display='2') " . $AdminDisplay . ") ORDER BY rank ASC ");
if ($siteurl != "") {
if ($sitetarget == '_self') {
if ($_GET[btn] == $siteid) {
echo "<li><a href=\"#\"><span>{$a[$siteid]}</span></a>";
if ($DbLink2->num_rows() > 0) {
echo "<ul>";
while (list($siteid2, $siteurl2, $sitetarget2) = $DbLink2->next_record()) {
WriteMenu($siteid2, $siteurl2, $sitetarget2, $a, $Display, $AdminDisplay);
}
echo "</ul>";
}
echo "</li>";
} else {
echo "<li><a href=\"{$siteurl}&btn={$siteid}\"><span>{$a[$siteid]}</span></a>";
if ($DbLink2->num_rows() > 0) {
echo "<ul>";
while (list($siteid2, $siteurl2, $sitetarget2) = $DbLink2->next_record()) {
WriteMenu($siteid2, $siteurl2, $sitetarget2, $a, $Display, $AdminDisplay);
}
echo "</ul>";
}
echo "</li>";
}
} else {
if ($sitetarget == '_external') {
echo "<li><a href=\"{$siteurl}\"><span>{$a[$siteid]}</span></a>";
if ($DbLink2->num_rows() > 0) {
echo "<ul>";
while (list($siteid2, $siteurl2, $sitetarget2) = $DbLink2->next_record()) {
WriteMenu($siteid2, $siteurl2, $sitetarget2, $a, $Display, $AdminDisplay);
}
echo "</ul>";
}
echo "</li>";
} else {
echo "<li><a href=\"#\" onclick=\"window.open('{$siteurl}','mywindow','')\"><span>{$a[$siteid]}</span></a>";
if ($DbLink2->num_rows() > 0) {
echo "<ul>";
while (list($siteid2, $siteurl2, $sitetarget2) = $DbLink2->next_record()) {
WriteMenu($siteid2, $siteurl2, $sitetarget2, $a, $Display, $AdminDisplay);
}
echo "</ul>";
}
echo "</li>";
}
}
} else {
echo "<li><a href=\\index.php?&page=smodul&id={$siteid}&btn={$siteid}\"><span>{$a[$siteid]}</span></a></li>";
}
}
示例2: displayCountry
function displayCountry()
{
$DbLink = new DB();
echo "<div class=\"roundedinput\"><select require=\"true\" label=\"country_label\" id=\"register_input\" wide=\"25\" name=\"country\" value=\"{$_SESSION['COUNTRY']}\">";
$DbLink->query("SELECT name FROM " . C_COUNTRY_TBL . " ORDER BY name ASC ");
echo "<option></option>";
while (list($COUNTRYDB) = $DbLink->next_record()) {
echo "<option>{$COUNTRYDB}</option>";
}
echo "</select></div>";
}
示例3: fopen
if (file_exists($toppath)) {
$fd = fopen($toppath, "rb");
$UR = fread($fd, filesize($toppath));
fclose($fd);
} elseif (file_exists($topgpath)) {
$fd = fopen($topgpath, "rb");
$UR = fread($fd, filesize($topgpath));
fclose($fd);
}
$DbLink = new DB();
$Room = stripslashes($R);
if ($UR == "") {
$UR = L_DEFAULT_TOPIC_1;
}
$DbLink->query("SELECT room FROM " . C_USR_TBL . " WHERE username='{$BOT_NAME}'");
list($BR) = $DbLink->next_record();
$DbLink->close();
$botcontrol = "botfb/" . $R . ".txt";
if ((file_exists($botcontrol) || $BR == $R) && C_BOT_PUBLIC) {
$Expl .= BOT_TIPS;
$Ex .= '<b>' . C_BOT_NAME . '</b> - ' . $Expl . '';
} elseif ($BR != "" && C_BOT_PUBLIC) {
$Expl .= sprintf(BOT_PRIV_TIPS, $BR);
$Ex .= '<b>' . C_BOT_NAME . '</b> - ' . $Expl . '';
} elseif (file_exists($botcontrol) && !C_BOT_PUBLIC) {
$Expl .= BOT_PRIVONLY_TIPS;
$Ex .= '<b>' . C_BOT_NAME . '</b> - ' . $Expl . '';
} else {
$Ex .= '';
}
$UR = stripslashes($UR);
示例4: stripslashes
} else {
// Check for invalid characters in the addressee name
# if (ereg("[\, \']", stripslashes($Cmd[2])))
if (preg_match("/[ |,|'|\\\\]/", $Cmd[2])) {
$Error = L_ERR_USR_16;
} elseif (mb_convert_case($U, MB_CASE_LOWER, $Charset) == mb_convert_case(trim($Cmd[2]), MB_CASE_LOWER, $Charset)) {
$Error = L_ERR_USR_27;
} elseif (mb_convert_case(trim($Cmd[2]), MB_CASE_LOWER, $Charset) == mb_convert_case(C_QUOTE_NAME, MB_CASE_LOWER, $Charset)) {
$Error = L_ERR_USR_1;
} elseif (trim($Cmd[2]) != "" && trim($Cmd[3]) != "") {
$Cmd[3] = "L_PRIV_WISP " . $Cmd[3];
if (C_PRIV_POPUP && !isset($allowpopupu)) {
$DbLink = new DB();
$DbLink->query("SELECT allowpopup FROM " . C_REG_TBL . " WHERE username = '{$Cmd['2']}'");
if ($DbLink->num_rows() != 0) {
list($allowpopupu) = $DbLink->next_record();
} else {
$allowpopupu = 0;
}
$DbLink->clean_results();
}
if (C_PRIV_POPUP) {
if ($allowpopupu || stristr(mb_convert_case(trim($Cmd[2]), MB_CASE_LOWER, $Charset), mb_convert_case(C_BOT_NAME, MB_CASE_LOWER, $Charset))) {
$Read = "Neww";
} else {
$Read = "Oldw";
}
} else {
$Read = "Oldw";
}
$DbLink->query("SELECT room FROM " . C_USR_TBL . " WHERE username='{$Cmd['2']}'");
示例5: array
$userName = $_GET['name'];
$found = array();
$found[0] = json_encode(array('Method' => 'GetProfile', 'WebPassword' => md5(WEBUI_PASSWORD), 'Name' => cleanQuery($_GET['name'])));
$do_post_requested = do_post_request($found);
$recieved = json_decode($do_post_requested);
$profileTXT = $recieved->{'profile'}->{'AboutText'};
$profileImage = $recieved->{'profile'}->{'Image'};
$created = $recieved->{'account'}->{'Created'};
$UUID = $recieved->{'account'}->{'PrincipalID'};
$diff = $recieved->{'account'}->{'TimeSinceCreated'};
$type = $recieved->{'account'}->{'AccountInfo'};
$partner = $recieved->{'account'}->{'Partner'};
$date = date("D d M Y - g:i A", $created);
}
$DbLink->query("SELECT id,\n displayTopPanelSlider, \n displayTemplateSelector,\n displayStyleSwitcher,\n displayStyleSizer,\n displayFontSizer,\n displayLanguageSelector,\n displayScrollingText,\n displayWelcomeMessage,\n displayLogo,\n displayLogoEffect,\n displaySlideShow,\n displayMegaMenu,\n displayDate,\n displayTime,\n displayRoundedCorner,\n displayBackgroundColorAnimation,\n displayPageLoadTime,\n displayW3c,\n displayRss FROM " . C_ADMINMODULES_TBL . " ");
list($id, $displayTopPanelSlider, $displayTemplateSelector, $displayStyleSwitcher, $displayStyleSizer, $displayFontSizer, $displayLanguageSelector, $displayScrollingText, $displayWelcomeMessage, $displayLogo, $displayLogoEffect, $displaySlideShow, $displayMegaMenu, $displayDate, $displayTime, $displayRoundedCorner, $displayBackgroundColorAnimation, $displayPageLoadTime, $displayW3c, $displayRss) = $DbLink->next_record();
?>
<!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=utf-8" />
<link rel="stylesheet" href="<?php
echo SYSURL;
echo $template_css;
?>
" type="text/css" />
<link rel="icon" href="<?php
echo SYSURL;
echo $favicon_image;
?>
示例6: date
$created = $recieved->{'account'}->{'Created'};
$uuid = $recieved->{'account'}->{'PrincipalID'};
$name = $recieved->{'account'}->{'Name'};
$diff = $recieved->{'account'}->{'TimeSinceCreated'};
$type = $recieved->{'account'}->{'AccountInfo'};
$email = $recieved->{'account'}->{'Email'};
$partner = $recieved->{'account'}->{'Partner'};
$rlname = $recieved->{'agent'}->{'RLName'};
$street = $recieved->{'agent'}->{'RLAddress'};
$zip = $recieved->{'agent'}->{'RLZip'};
$city = $recieved->{'agent'}->{'RLCity'};
$country = $recieved->{'agent'}->{'RLCountry'};
$date = date("D d M Y - g:i A", $created);
$DbLink->query("SELECT PrincipalID,Name FROM ".C_USERS_TBL." WHERE PrincipalID='".cleanQuery($_GET[userid])."'");
list($uuid,$accName) = $DbLink->next_record();
$DbLink->query("SELECT UserLevel FROM ".C_USERS_TBL." a where PrincipalID='".cleanQuery($_GET[userid])."'");
list($active) = $DbLink->next_record();
if($active == "-1")
$active = "0";
else
$active = "1";
?>
<div id="content">
<div id="ContentHeaderLeft"><h5><?php
示例7: WHERE
if (C_CHAT_LOGS) {
$ChatM->query("DELETE FROM " . C_MSG_TBL . " WHERE username = 'SYS enter' AND message LIKE '%\"" . C_BOT_NAME . "\"%' AND m_time != '" . $bot_time . "'");
require "logs.lib.php";
} else {
$ChatM->query("DELETE FROM " . C_MSG_TBL . " WHERE ((m_time<'" . (time() - C_MSG_DEL * 60 * 60) . "' AND pm_read NOT LIKE 'New%') OR (m_time<'" . (time() - (C_MSG_DEL + C_PM_KEEP_DAYS * 24) * 60 * 60) . "')) AND !(username = 'SYS enter' AND message LIKE '%\"" . C_BOT_NAME . "\"%' AND m_time != '" . $bot_time . "')");
}
// Clean the lurkers table
if (C_CHAT_LURKING) {
$ChatLurk = new DB();
$ChatLurk->query("DELETE FROM " . C_LRK_TBL . " WHERE time<'" . (time() - 15) . "'");
$CleanUsrTbl = $ChatLurk->affected_rows() > 0;
$ChatLurk->close();
}
$Chat = new DB();
$Chat->query("SELECT room,username,u_time,status FROM " . C_USR_TBL . " WHERE username != '" . C_BOT_NAME . "' AND (u_time<'" . (time() - 60) . "' OR (status = 'k' AND u_time<'" . (time() - 20) . "'))");
while (list($userroom, $userclosed, $usertime, $statusclosed) = $Chat->next_record()) {
// $when = date('r', $usertime + C_TMZ_OFFSET*60*60);
$when = $usertime + C_TMZ_OFFSET * 60 * 60;
$when = stristr(PHP_OS, 'win') ? '\\".utf_conv(WIN_DEFAULT,$Charset,strftime(L_LONG_DATETIME,' . $when . ')).\\"' : '\\".strftime(L_LONG_DATETIME,' . $when . ').\\"';
$ChatM->query("SELECT type FROM " . C_MSG_TBL . " WHERE room = '" . $userroom . "' ORDER BY m_time DESC LIMIT 1");
list($usertype) = $ChatM->next_record();
$userclosed = addslashes($userclosed);
// Ghost Control mod by Ciprian
if (C_SPECIAL_GHOSTS != "") {
$sghosts = "";
$sghosts = str_replace("'", "", C_SPECIAL_GHOSTS);
$sghosts = str_replace(" AND username != ", ",", $sghosts);
}
if ($sghosts != "" && ghosts_in($userclosed, $sghosts, $Charset) || C_HIDE_ADMINS && ($statusclosed == "a" || $statusclosed == "t") || C_HIDE_MODERS && $statusclosed == "m") {
} else {
$ChatM->query("INSERT INTO " . C_MSG_TBL . " VALUES ('" . $usertype . "', '" . $userroom . "', 'SYS exit', '', '" . time() . "', '', 'sprintf(L_CLOSED_ROM, \"(" . $when . ") " . $userclosed . "\")', '', '')");
示例8: list
$DbLink->query('SELECT ' . C_USR_TBL . '.room, ' . C_USR_TBL . '.status, ' . C_USR_TBL . '.ip' . ' FROM ' . C_USR_TBL . ', ' . C_REG_TBL . ' WHERE ' . C_USR_TBL . '.username = \'' . $U . '\'' . ' AND ' . C_REG_TBL . '.username = \'' . $U . '\'' . ' AND ' . C_REG_TBL . '.password = \'' . $PWD_Hash . '\'' . ' LIMIT 1');
} else {
$DbLink->query('SELECT username FROM ' . C_REG_TBL . ' WHERE username = \'' . $U . '\' LIMIT 1');
if ($DbLink->num_rows() == 0) {
$DbLink->query('SELECT room, status, ip FROM ' . C_USR_TBL . ' WHERE username = \'' . $U . '\' LIMIT 1');
} else {
$DbLink->clean_results();
$DbLink->close();
exit;
// hack attack
}
}
}
// End of SeazoN Fix
if ($DbLink->num_rows() != 0) {
list($room, $status, $knownIp) = $DbLink->next_record();
$DbLink->clean_results();
$kicked = 0;
// Security issue
include "./lib/get_IP.lib.php";
if ($knownIp != $IP) {
$kicked = 5;
}
// Update users info
if ($room != stripslashes($R)) {
$DbLink->query("INSERT INTO " . C_MSG_TBL . " VALUES ({$T}, '{$R}', 'SYS exit', '', " . time() . ", '', 'sprintf(L_EXIT_ROM, \"" . special_char($U, $Latin1) . "\")', '', '')");
$kicked = 3;
} elseif ($status == "k") {
$kicked = 1;
} elseif ($status == "d") {
$kicked = 2;
示例9: check_internet_connection
* Check Internet Connection.
*
* @param string $sCheckHost Default: www.google.com
* @return boolean
*/
function check_internet_connection($sCheckHost = 'www.google.com')
{
return (bool) @fsockopen($sCheckHost, 80, $iErrno, $sErrStr, 2);
}
/*********** PART I ***********/
// Define the message to display if user comes here because he has been kicked
$Reason = "";
$Reason_all = "";
$DbLink = new DB();
$DbLink->query("SELECT message FROM " . C_MSG_TBL . " WHERE message LIKE 'sprintf(L_KICKED_REASON, \"" . $U . "\", %' AND m_time>" . (time() - 30) . " LIMIT 1");
$kickeduser = list($message) = $DbLink->next_record();
$DbLink->clean_results();
// The user has been kicked for a reason
if ($kickeduser) {
$Reason = trim($message, "sprintf(L_KICKED_REASON, \".{$U}.\", ");
$Reason = trim($Reason, "\")");
}
$DbLink->query("SELECT message FROM " . C_MSG_TBL . " WHERE message LIKE 'sprintf(L_KICKED_ALL_REASON, \"%' AND m_time>" . (time() - 30) . " LIMIT 1");
$kickeduser_all = list($message) = $DbLink->next_record();
$DbLink->clean_results();
// The user has been kicked for a reason
if ($kickeduser_all) {
$Reason_all = trim(str_replace("sprintf(L_KICKED_ALL_REASON, \"", "", $message));
$Reason_all = trim($Reason_all, "\")");
}
$DbLink->query("SELECT message FROM " . C_MSG_TBL . " WHERE message LIKE 'sprintf(L_BANISHED_REASON, \"" . $U . "\", %' AND m_time>" . (time() - 30) . " LIMIT 1");
示例10: array
<?
if($_GET[code]){
$DbLink = new DB;
$DbLink->query("SELECT UUID, email FROM ".C_CODES_TBL." WHERE code='".cleanQuery($_GET[code])."' and info='emailconfirm'");
list($UUID, $EMAIL) = $DbLink->next_record();
}
if($UUID)
{
$found = array();
$found[0] = json_encode(array('Method' => 'SaveEmail', 'WebPassword' => md5(WEBUI_PASSWORD)
, 'UUID' => cleanQuery($UUID)
, 'Email' => cleanQuery($EMAIL)));
$do_post_requested = do_post_request($found);
$recieved = json_decode($do_post_requested);
if ($recieved->{'Verified'} == 1)
{
$WERROR="Thank you, your email address was changed";
$DbLink->query("DELETE FROM ".C_CODES_TBL." WHERE code='".cleanQuery($_GET[code])."' and info='emailconfirm'");
}
}
else
{
$WERROR="This isnt a valid code or maybe the code was older than 24h";
}
?>
<style type="text/css">
<!--
示例11: stripslashes
}
}
$OthersUsers->query($otherRoomsQuery);
if ($OthersUsers->num_rows() > 0) {
$notEmptyRooms[$Other] = 1;
// Restricted rooms mod by Ciprian
$tmpDispOther = $Other;
$tmpDispOtherRes = "";
if (is_array($DefaultDispChatRooms) && in_array($Other . " [R]", $DefaultDispChatRooms)) {
$tmpDispOther .= " [" . $res_init . "]";
$tmpDispOtherRes = " (" . L_RESTRICTED . ")";
}
echo "<DIV style=\"margin-top: 1px;\">";
echo "<a href=\"{$From}?Ver=L&L={$L}&U=" . stripslashes($U) . "{$AddPwd2Link}&R1=" . urlencode(stripslashes($Other)) . "&T=1&D={$D}&N={$N}&E=" . urlencode(stripslashes($R)) . "&EN={$T}" . (isset($RemMe) ? "&RM=1" : "") . "\" TARGET=\"_parent\" onMouseOver=\"window.status='" . L_JOIN_ROOM . $tmpDispOtherRes . "'; return true;\" title='" . L_JOIN_ROOM . $tmpDispOtherRes . "'>" . htmlspecialchars($tmpDispOther) . "</a><SPAN CLASS=\"small\"><BDO dir=\"{$textDirection}\"></BDO> (" . $OthersUsers->num_rows() . ")</SPAN><br />\n";
echo "</DIV>\n";
while (list($OtherUser, $Latin1, $status, $awaystat, $room_time, $gender, $allowpopup, $colorname, $avatar, $email, $use_gravatar) = $OthersUsers->next_record()) {
echo "<DIV style=\"margin-top: 1px; margin-left: 12px\">\n";
if (C_USE_AVATARS && !C_DISP_GENDER) {
// Avatar System Start: Inserted:
if (empty($avatar)) {
$avatar = C_AVA_RELPATH . C_DEF_AVATAR;
}
// Gravatar mod added by Ciprian
if (ALLOW_GRAVATARS == 2 || ALLOW_GRAVATARS == 1 && (!isset($use_gravatar) || $use_gravatar)) {
# if (eregi(C_AVA_RELPATH, $avatar)) $local_avatar = 1;
if (stripos($avatar, C_AVA_RELPATH) !== false) {
$local_avatar = 1;
} else {
$local_avatar = 0;
}
require "plugins/gravatars/get_gravatar.php";
示例12:
echo "<script language='javascript'>
<!--
window.location.href='index.php?page=smodul&id=1&btn=1&ERROR=$ERROER';
// -->
</script>";
}else{
echo "<script language='javascript'>
<!--
window.location.href='index.php?page=smodul&id=1&btn=1';
// -->
</script>";
}
}
list($content) = $DbLink->next_record();
?>
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top">
<div style="height:100%;">
<?php
echo $content;
?>
</div>
</td>
</tr>
</table>
示例13:
<?
$DbLink = new DB;
$DbLink->query("SELECT adress,region FROM ".C_ADM_TBL."");
list($ADRESSCHECK,$REGIOCHECK) = $DbLink->next_record();
//GET IP ADRESS
if ($_SERVER["HTTP_X_FORWARDED_FOR"])
{
$userIP = $_SERVER["HTTP_X_FORWARDED_FOR"];
}
elseif ($_SERVER["REMOTE_ADDR"])
{
$userIP = $_SERVER["REMOTE_ADDR"];
}
else
{
$userIP="This user has no ip";
}
//GET IP ADRESS END
if($_GET[aktion]=="")
{
if($_POST[action]=="")
{
?>
<style type="text/css">
<!--
.box {
font-size: 12px;
height: 20;
}
示例14: isset
<?php
$SessionUserID = isset($_SESSION['Athlete_id']) ? $_SESSION['Athlete_id'] : 0;
$rating_func = new COMMONFUNC();
$rating_db = new DB();
if ($SessionUserID > 0) {
$query = "Select * from tbl_athelete_register where fldId = '{$SessionUserID}' ";
$rating_db->query($query);
$rating_db->next_record();
$totalPages = $rating_db->num_rows();
if ($totalPages > 0) {
$UserID = $rating_db->f('fldId');
$uploadImage = $rating_db->f('fldImage');
$coachApprove = $rating_db->f('fldApproveCoachId');
$uploadVideo = $rating_func->GetValue("tbl_athlete_video", "fldId", "fldAthleteId", $rating_db->f('fldId'));
$uploadGameSchedule = $rating_func->GetValue("tbl_event", "fldEventId", "fld_UserType='athlete' AND fldUserName", $rating_db->f('fldUsername'));
$fldGPA = $rating_func->output_fun($rating_db->f('fldGPA'));
$fldSATScore = $rating_func->output_fun($rating_db->f('fldSATScore'));
$fldACTScore = $rating_func->output_fun($rating_db->f('fldACTScore'));
$fldClassRank = $rating_func->output_fun($rating_db->f('fldClassRank'));
$fldClearinghouseEligible = $rating_func->output_fun($rating_db->f('fldClearinghouseEligible'));
$fldIntendedMajor = $rating_func->output_fun($rating_db->f('fldIntendedMajor'));
$fldClass = $rating_func->output_fun($rating_db->f('fldClass'));
$fldHeight = $rating_func->output_fun($rating_db->f('fldHeight'));
$fldWeight = $rating_func->output_fun($rating_db->f('fldWeight'));
$fldSport = $rating_func->output_fun($rating_db->f('fldSport'));
//$fldJerseyNumber = $rating_func -> output_fun($rating_db -> f('fldJerseyNumber'));
$fldPrimaryPosition = $rating_func->output_fun($rating_db->f('fldPrimaryPosition'));
$fldSecondaryPosition = $rating_func->output_fun($rating_db->f('fldSecondaryPosition'));
$fldVertical = $rating_func->output_fun($rating_db->f('fldVertical'));
$fld40_yardDash = $rating_func->output_fun($rating_db->f('fld40_yardDash'));
示例15: array
$fldSecondaryPosition = $rating_func->output_fun($profile_db->f('fldSecondaryPosition'));
$fldVertical = $rating_func->output_fun($profile_db->f('fldVertical'));
$fld40_yardDash = $rating_func->output_fun($profile_db->f('fld40_yardDash'));
$fldShuttleRun = $rating_func->output_fun($profile_db->f('fldShuttleRun'));
$fldBenchPressMax = $rating_func->output_fun($profile_db->f('fldBenchPressMax'));
$fldSquatMax = $rating_func->output_fun($profile_db->f('fldSquatMax'));
####### APPROVED_BY_COACH ################
if ($coachApprove == 0 || $coachApprove == "") {
// mail to Coach for pending approval request
//User Selected School
$schoolid = $fldSchool;
$sportid = $fldSport;
$emailarr = array();
$selquery = 'select first.fldId,first.fldEmail as fldEmail,first.fldName as name,first.fldLastName as lname,first.fldUsername as HSCoachUsername,first.fldPassword as HSCoachPassword from ' . TBL_HS_AAU_COACH . ' first,' . TBL_HS_AAU_COACH_SPORT_POSITION . ' second where second.fldCoachNameId = first.fldId and second.fldSportId =' . $sportid . ' and first.fldSchool =' . $schoolid;
$coach_db->query($selquery);
$coach_db->next_record();
if ($coach_db->num_rows() > 0) {
for ($i = 0; $i < $coach_db->num_rows(); $i++) {
$emailarr[] = $rating_func->output_fun($coach_db->f('fldEmail'));
$name = $rating_func->output_fun($coach_db->f('name'));
$lname = $rating_func->output_fun($coach_db->f('lname'));
#Login Info
$HSCoachUsername = $rating_func->output_fun($coach_db->f('HSCoachUsername'));
$HSCoachPassword = $rating_func->output_fun($coach_db->f('HSCoachPassword'));
$db->next_record();
}
foreach ($emailarr as $key => $emailvalue) {
######################## EMAIL to HS COACH - Athlete Approval Notification ########################
#Subject
$subjectStre = "College Prospect Network - Athlete Pending Approval";
#Intro