} } echo $strcombo = '</select>'; ?> <a href="ADAthleteCatagoryAdd.php">Add New</a> </td> </tr> <?php } #Code for paging $page->set_page_data('', $db1->num_rows(), 100, 5, true, false, true); $page->set_qry_string($queryString); $query = $page->get_limit_query($query); //return the query with limits $db1->query($query); $db1->next_record(); if ($db1->num_rows() > 0) { #check for record availability echo '<tr><td align="center" class="normalblack_12" width="4%"> </td> <td align="left" class="normalblack_12" width="8%"> <strong>S.No.</strong></td> <td align="left" class="normalblack_12" width="25%"> <strong>Category Name</strong></td> <td align="left" class="normalblack_12" width="15%"> <strong>Category (Initials)</strong></td> '; echo '<td class="normalblack_12" width="5%" align="center"><strong>Edit</strong></td>'; echo '<td class="normalblack_12" width="7%" align="center"><strong>Delete</strong></td>'; echo '<td class="normalblack_12" width="7%" align="center"><strong>View</strong></td>'; echo '</tr>';
$query = " Select * from " . TBL_HS_AAU_TEAM_NAME . " where fldStatus=1"; } else { $query = "Select * from " . TBL_HS_AAU_TEAM_NAME . " where " . $srchCond; } $db->query($query); $db->next_record(); $totalPages = $db->num_rows(); if ($totalPages > 0) { ?> <tr> <td align="left" style="padding-left:7px;"colspan="10"><input type="checkbox" id="check_all" name="check_all" value="" onclick="javascript:checkAll();"> <b>Check All</b> <input type="button" name="delete" value="Delete Selected" onclick="return submitDeleteAll();"></td></tr> <?php } #Code for paging $page->set_page_data('', $db->num_rows(), 100, 5, true, false, true); $page->set_qry_string($queryString); $query = $page->get_limit_query($query); //return the query with limits //echo $query; //echo $queryString; $db->query($query); $db->next_record(); if ($db->num_rows() > 0) { #check for record availability echo '<tr><td align="center" class="normalblack_12" width="4%"> </td> <td align="left" class="normalblack_12" width="8%"> <strong>S.No.</strong></td> <td align="left" class="normalblack_12" width="25%"> <strong>HS AAU Team Name</strong></td> '; echo '<td class="normalblack_12" width="5%" align="center"><strong>Edit</strong></td>';
echo "<p><label>To: </label><span>{$fullname}</span></p>"; echo "<p><label>Subject:</label><span>{$Subject}</span></p>"; echo "<p><label>Message:</label><span style='line-height:18px;'>{$Message}</span></p>"; $Subjectnew = str_replace(" ", "%", $Subject); echo "<p style='padding-top:10px;height:50px;line-height:18px;display:none;'><a href=Athmessage.php?action=compose&to={$fullname}&subject=RE: {$Subjectnew}&Usertypefrom={$Usertypefrom}&newfrom={$UserTo} class='mailaction'>Forward Message</a></p>"; } ////////////////////////////Viewssent/////////////////////////////// ////////////////////////////Biginning Inbox/////////////////////////////// if ($action == inbox || $action == '') { $selquery = "select * from " . TBL_MAIL . " where UserTo='{$username}' and status!='delete' and visible = 'ACTIVE' order by mail_id DESC"; $db->query($selquery); $db->next_record(); $totalPages = $db->num_rows(); #Code for paging $page->set_page_data('', $db->num_rows(), 20, 5, true, false, true); $page->set_qry_string($selquery); $selquery = $page->get_limit_query($selquery); //return the query with limits $db->query($selquery); $db->next_record(); if ($db->num_rows() == '0') { if ($_REQUEST['msg'] == '') { echo '<div class="thankyoumessage">Your Inbox is Empty!</div>'; } } else { #echo "<h3 class='black'>Inbox</h3>"; echo "<table cellpadding=2 cellspacing=1 width='100%' align='center'>"; echo '<tr> <td align="left" class="normalblack_12" width="10%"><strong>Date</strong></td> <td align="left" class="normalblack_12" width="45%"><strong>Subject</strong></td> <td align="left" class="normalblack_12" width="30%"><strong>From User</strong></td>
<body> <?php include 'header.php'; ?> <!--middle panel starts from here --> <!--content panel starts from here --> <div class="container"> <div class="innerWraper"> <div class="middle-bg"> <div class="cantener"> <div class="register-main"> <div class="registerPage"> <h1>Find Colleges for Your Network</h1> <table cellspacing="2" cellpadding="5" bordercolor="#808080" border="0" width="100%" class="tablePadd" style="border-collapse: collapse;"> <tr> <td align='center' colspan='4' height='30' valign='middle' width="100%"><font class="thankyoumessage"><?php if ($_REQUEST['msg'] != "") { echo $_REQUEST['msg']; } else { echo " "; } ?> </font></td> </tr> <tr> <td align="right" colspan='4' height='30' valign='middle'> <form name="searchFrm" id="searchFrm" action="<?php echo $PHP_SELF; ?> " method="POST"> <input type="hidden" name="page" id="page" value="0">
if ($_REQUEST['division'] == 'DivisionI') { echo '<option value="DivisionI" selected="selected">Division I</option>'; } else { echo '<option value="DivisionI">Division I</option>'; } if ($_REQUEST['division'] == 'DivisionII') { echo '<option value="DivisionII" selected="selected">Division II</option>'; } else { echo '<option value="DivisionII">Division II</option>'; } if ($_REQUEST['division'] == 'DivisionIII') { echo '<option value="DivisionIII" selected="selected">Division III</option>'; } else { echo '<option value="DivisionIII">Division III</option>'; } if ($_REQUEST['division'] == 'NAIA') { echo '<option value="NAIA" selected="selected">NAIA</option>'; } else { echo '<option value="NAIA">NAIA</option>'; } if ($_REQUEST['division'] == 'JUCO') { echo '<option value="JUCO" selected="selected">JUCO</option>'; } else { echo '<option value="JUCO">JUCO</option>'; } echo '</select>'; ?> </span> </p> <?php if ($_REQUEST['mode'] == "div") {
$where .= AthleteSearchHelper::getMajorCond($fldIntendedMajor); $where .= AthleteSearchHelper::getSchoolCond($fldSchool); $where .= AthleteSearchHelper::getStateCond($fldState); $where .= AthleteSearchHelper::getSchoolsInDistance($fldZipCode, $fldDistance); $query = $select . $where; // creates pagination if (!$db->query($query)) { die(mysql_error() . '<br>' . $query); } $page = new Page(); $page->set_page_data('', $db->num_rows(), 10, 5, true, false, true); $data = $_GET; unset($data['page']); unset($data['submit']); if (count($data) > 0) { $page->set_qry_string(http_build_query($data)); } $query = $page->get_limit_query($query); // retrieves athletes matching search critera from the // database and parses the results to be redered to the page if (!$db->query($query)) { die(mysql_error() . '<br>' . $query); } if ($db->num_rows() == 0) { $isError = TRUE; $errorMsg = 'We currently do not have any available athletes meeting ' . 'your search criteria. Please broaden the criteria to find ' . 'the athlete you are looking for.'; } while ($db->next_record()) { $a = new Athlete(); $a->gradClass = htmlentities($db->f('fldClass')); $a->fname = htmlentities($db->f('fldFirstname'));
$db->next_record(); $count++; } #show pagination echo '<tr><td align="right" class="normalblack_12x" colspan="5">'; echo '</td></tr>'; } echo '</form></table></span>'; ?> </div> <div style="background: none repeat scroll 0 0 #FFFFFF; border: 1px solid #DBDBDB; min-height: 120px; margin-top:11px; width: 567px;float:right"> <form name="frmUsers_need" action="" method="post" onsubmit=""> <span class="gernal">Coach's Needs</span> <br /><br /> <?php if ($_REQUEST['page'] == '') { $pageno = '0'; } else { $pageno = $_REQUEST['page']; } if ($_SESSION['mode'] == 'college') { ?> <a href="#" onclick="window.open('collegeneed.php','windowname1', 'width=665, height=650'); return false;">Add Needs</a> <?php } ?>