CURDATE() ORDER BY year ASC"; $listclass = mysql_query($query_listclass, $theudb) or die(mysql_error()); $row_listclass = mysql_fetch_assoc($listclass); $totalRows_listclass = mysql_num_rows($listclass); $query_expiredclasses = "SELECT * FROM recruits_class WHERE expires < CURDATE() ORDER BY year ASC"; $expiredclasses = mysql_query($query_expiredclasses, $theudb) or die(mysql_error()); $row_expiredclasses = mysql_fetch_assoc($expiredclasses); $totalRows_expiredclasses = mysql_num_rows($expiredclasses); ///END VIEW OPTION BOX //LIST POSITION WHEN in thumblist and Thumbnail VIEW if (( $display == 'tlist' ) || ( $display == 'thumb' ) ) { ////////////// VIEW ONLY BY GET POSITION if ( $_GET['pos'] == '' ) { $query_listpos2 = "SELECT * FROM recruits_positions WHERE category = $reccatID ORDER BY pageorder ASC"; } else { $pos = $_GET['pos']; $query_listpos2 = "SELECT * FROM recruits_positions WHERE category = $reccatID and id = $pos ORDER BY pageorder ASC"; } $listpos2 = mysql_query($query_listpos2, $theudb) or die(mysql_error()); $row_listpos2 = mysql_fetch_assoc($listpos2); $totalRows_listpos2 = mysql_num_rows($listpos2); } ////////Get recruiting news if ( $catID == 3 ) { $newscat = 1; //football } else if ( $catID == 4 ) { $newscat = 2; //basketball } else { $newscat = 3; //baseball } if ( $_GET['display'] == '' ) { $query_gettopstory = "SELECT DATE_FORMAT( date, '%b. %e, %Y' ) as mydate, id, title, writer, tags, relate_recruit, photofilename, thumbnail, caption, description, news_key, category, premium, story, feature FROM news WHERE category = $newscat ORDER BY id DESC"; $gettopstory = mysql_query($query_gettopstory, $theudb) or die(mysql_error()); $row_gettopstory = mysql_fetch_assoc($gettopstory); $totalRows_gettopstory = mysql_num_rows($gettopstory); $topID = $row_gettopstory['id']; if ( $totalRows_gettopstory != 0 ) { $query_morenews = "SELECT DATE_FORMAT( date, '%b. %e, %Y' ) as mydate, id, title, writer, tags, relate_recruit, photofilename, thumbnail, caption, description, news_key, category, premium FROM news WHERE id != $topID and category = $newscat ORDER BY id DESC LIMIT 6"; $morenews = mysql_query($query_morenews, $theudb) or die(mysql_error()); $row_morenews = mysql_fetch_assoc($morenews); $totalRows_morenews = mysql_num_rows($morenews); $writeID = $row_gettopstory['writer']; $query_getstaff = "SELECT * FROM staff WHERE id = $writeID"; $getstaff = mysql_query($query_getstaff, $theudb) or die(mysql_error()); $row_getstaff = mysql_fetch_assoc($getstaff); $totalRows_getstaff = mysql_num_rows($getstaff); } //no top story found } function imageResize($width, $height, $target) { //takes the larger size of the width and height and applies the //formula accordingly...this is so this script will work //dynamically with any size image if ($width > $height) { $percentage = ($target / $width); } else { $percentage = ($target / $height); } //gets the new value and applies the percentage, then rounds the value $width = round($width * $percentage); $height = round($height * $percentage); //returns the new sizes in html image tag format...this is so you //can plug this function inside an image tag and just get the return "width=\"$width\" height=\"$height\""; } ?>
Currently no Stories, come back soon. 250 ) { ?> >
|
More News
Currently no other news
|
View by position: | ALL » View by class: | ALL » |
|
|||
|
Other Interested Schools: n/a
|
|||||||||
|
Currently no recruits. |
|
Other Interested Schools: n/a
|
|||||||||
|
Currently no recruits. |
|
|||||||||||||||||||||||||||||||||||||||||||||||||
|
||||