$Countahtlete_pending = "(<font style='color:red;'>" . $Countahtlete_pending . " Pending</font>)"; } else { $Countahtlete_pending = ""; } ?> <p><img src="img/bullet-grey.gif"><a href="CoachAthapprove.php">Athlete Approval <?php echo $Countahtlete_pending; ?> </a> </p> <?php //Count Pending Athlete Stats $ahtlete_stat_pending = $func->selectTableOrdergroupby(TBL_ATHELETE_STAT, "fldAtheleteId,fldStatus,fldPrograme", "fldPrograme", "where fldCoachId='" . $_SESSION['Coach_id'] . "' and fldStatus = '0'"); $Countahtlete_stat_pending = count($ahtlete_stat_pending); if ($Countahtlete_stat_pending > 0) { $Countahtlete_stat_pending = "(<font style='color:red;'>" . $Countahtlete_stat_pending . " Pending</font>)"; } else { $Countahtlete_stat_pending = ""; } ?> <p><img src="img/bullet-grey.gif"><a href="ViewAthletesStats.php">Athlete Stats Approval <?php echo $Countahtlete_stat_pending; ?> </a> </p>
echo $fldHSCoachName; ?> "> </span><font color="#0000ff"> *</font> </p> <p> <label>High School:</label> <span> <select name="fldSchool" id="fldSchool" style="width:276px" > <!--onchange="select_val(this.value)"--> <option value="select" class="selectgrey">Select High School</option> <?php #$categorylist = $func -> selectTableOrdergroupby(TBL_HS_AAU_TEAM, "fldId,fldSchoolname", "fldState"); #for ($i = 0; $i < count($categorylist); $i++) { #echo '<option value ="' . $categorylist[$i]['fldId'] . '" >' . $categorylist[$i]['fldSchoolname'] . '</option>'; #} $statelist = $func2->selectTableOrdergroupby(TBL_HS_AAU_TEAM, "fldState", "fldState", "WHERE fldStatus='ACTIVE'"); for ($x = 0; $x < count($statelist); $x++) { echo '<optgroup label="========' . $statelist[$x]['fldState'] . '========">'; #echo '<option value ="' . $statelist[$x]['fldState'] . '" >' . $statelist[$x]['fldState'] . '</option>'; $whereclaus = "WHERE fldState = '" . $statelist[$x]['fldState'] . "' "; $categorylist = $func->selectTableOrder(TBL_HS_AAU_TEAM, "fldId,fldSchoolname", "fldSchoolname", $whereclaus); for ($i = 0; $i < count($categorylist); $i++) { ?> <option value ="<?php echo $categorylist[$i]['fldId']; ?> "<?php if ($categorylist[$i]['fldId'] == $fldSchool) { ?> selected="selected" <?php }
public static function getSchoolList() { $func = new COMMONFUNC(); $schoolList = array(); $groups = $func->selectTableOrdergroupby(TBL_HS_AAU_TEAM, "fldState", "fldState", "WHERE fldStatus='ACTIVE'"); for ($i = 0; $i < count($groups); $i++) { $groupLabel = '========' . $groups[$i]['fldState'] . '========'; $schoolList[$groupLabel] = array(); //School Loop (in state) $where = "WHERE fldState='" . $groups[$i]['fldState'] . "'"; $schools = $func->selectTableOrder(TBL_HS_AAU_TEAM, "fldId,fldSchoolname", "fldSchoolname", $where); for ($j = 0; $j < count($schools); $j++) { $key = $schools[$j]['fldId']; $value = $schools[$j]['fldSchoolname']; $schoolList[$groupLabel][$key] = $value; } } return $schoolList; }
$query1 = "SELECT fldSport from " . TBL_ATHELETE_REGISTER . " WHERE fldUsername='******'"; $db1->query($query1); $db1->next_record(); $fldSport = $func->output_fun($db1->f('fldSport')); if ($_SESSION['mode'] == 'coach' || $_SESSION['mode'] == 'college') { echo "<h2 style='padding-left:160px;'>Send Message to HS/AAU Coach</h2><br><form name='messageform' action='' method=post onsubmit='return validate()'>"; echo "<p><label>To:</label><span>"; echo $strcombo = '<select name="to" style="width:276px">'; echo $strcombo = '<option value="">----- Please Select -----</option>'; $coachlist = $func->selectTableOrder(TBL_HS_AAU_COACH, "fldId,fldName,fldLastName,fldUsername", "fldLastName"); } else { echo "<h2 style='padding-left:160px;'>Send Message to HS/AAU Coach</h2><br><form name='messageform' action='' method=post onsubmit='return validate()'>"; echo "<p><label>To:</label><span>"; echo $strcombo = '<select name="to" style="width:276px">'; echo $strcombo = '<option value = "">----- Please Select -----</option>'; $coachlist = $func->selectTableOrdergroupby("tbl_hs_aau_coach_sportposition cs, tbl_hs_aau_coach ac", "fldId,fldName,fldLastName,fldUsername", "ac.fldLastName", "where ac.fldId = cs.fldCoachNameId and cs.fldSportId = " . $fldSport); } for ($i = 0; $i < count($coachlist); $i++) { if (!in_array($coachlist[$i]['fldId'], $coachid)) { if ($_REQUEST['to'] == $coachlist[$i]['fldUsername']) { echo '<option value ="' . $coachlist[$i]['fldUsername'] . '" selected="selected" >' . ucfirst($coachlist[$i]['fldLastName']) . ', ' . ucfirst($coachlist[$i]['fldName']) . '</option>'; } else { echo '<option value ="' . $coachlist[$i]['fldUsername'] . '">' . ucfirst($coachlist[$i]['fldLastName']) . ', ' . ucfirst($coachlist[$i]['fldName']) . '</option>'; } } } echo $strcombo = '</select>'; } else { if ($_REQUEST['value'] == 'athlete') { ##TO ATHLETE## echo "<h2 style='padding-left:160px;'>Send Message to an Athlete</h2><br><form name='messageform' action='' method=post onsubmit='return validate()'>";
<span> <input type="text" name="fldAlternativePhone" id="fldAlternativePhone" value="<?php echo $fldAlternativePhone; ?> " > </span> </p> <hr class="line" /> <p> <label>College:</label> <span> <?php echo $strcombo = '<select name="fldCollegename" id="fldSchool">'; echo $strcombo = '<option value="select" class="selectgrey">Select College</option>'; $statelist = $func2->selectTableOrdergroupby(TBL_COLLEGE, "fldState", "fldState", "WHERE fldStatus='1'"); for ($x = 0; $x < count($statelist); $x++) { echo '<optgroup label="========' . $statelist[$x]['fldState'] . '========">'; $whereclaus = "WHERE fldState = '" . $statelist[$x]['fldState'] . "' "; $collegelist = $func->selectTableOrder(TBL_COLLEGE, "fldId,fldName", "fldName", $whereclaus); for ($i = 0; $i < count($collegelist); $i++) { echo '<option value ="' . $collegelist[$i]['fldId'] . '" >' . $collegelist[$i]['fldName'] . '</option>'; } echo '<option value ="other" class="addcustom_normal">****Other (Add Your College) ****</option>'; echo '</optgroup>'; } echo '<option value ="other" class="addcustom">Not Listed? Add Your College</option>'; echo $strcombo = '</select>'; ?> </span><font color="#0000ff">*</font> </p>