|
|
| Viewing: Girls Basketball » All Positions » All Classes » Committed | |||||
|
|
|
|
|||
|
|
|
|
|
|
|
|
|
||||||||||||
|
$firstone = 1;
$doprimaryloop = 1;
//do { //////////////////////////////Loop thru listrecruits
if($topposaddon == 1) { //A POSITION IS CLICKED
$wherelist = 'WHERE recruits.position = '.$clickpos;
$query_getrectotal = "SELECT count(*) from recruits $wherelist ";
$getrectotal = mysql_query($query_getrectotal, $floridaprospects) or die(mysql_error());
$row_getrectotal = mysql_fetch_assoc($getrectotal);
} else if($topclassaddon == 1) { //A CLASS IS CLICKED
//when all is displayed and sorting by class, check to see if a top class was clicked or not
if($clickclass == '') {
$wherelist = 'WHERE recruits.sport = 3';
} else {
$wherelist = 'WHERE recruits.year_class = '.$clickclass.' && recruits.sport = 3';
}
$query_getrectotal = "SELECT count(*) from recruits $wherelist ";
$getrectotal = mysql_query($query_getrectotal, $floridaprospects) or die(mysql_error());
$row_getrectotal = mysql_fetch_assoc($getrectotal);
} else if($topcomaddon == 1) { //COMMITTED OR NOT IS CLICKED
$wherelist = 'WHERE recruits.committed = "'.$clickcom.'" && recruits.sport = 3';
$query_getrectotal = "SELECT count(*) from recruits $wherelist ";
$getrectotal = mysql_query($query_getrectotal, $floridaprospects) or die(mysql_error());
$row_getrectotal = mysql_fetch_assoc($getrectotal);
} else { //GOING TO LIST ALL FOR THIS SPORT
$wherelist = 'WHERE recruits.sport = 3 ';
$query_getrectotal = "SELECT count(*) from recruits $wherelist ";
$getrectotal = mysql_query($query_getrectotal, $floridaprospects) or die(mysql_error());
$row_getrectotal = mysql_fetch_assoc($getrectotal);
}
//} //by
$query_listrecs = "SELECT recruits_college.name as collegename, recruits_position.id, recruits_position.pname, recruits_position.abrev, recruits_class.id as classid, recruits_class.year, recruits_highschool.id as hschoolid, recruits_highschool.name as hschool, recruits_town.id as townid, recruits_town.town, recruits_town.state, recruits.r_id, recruits.firstname, recruits.lastname, recruits.position2, recruits.fprank, recruits.photofilename, recruits.thumbnail, recruits.height, recruits.height_display, recruits.weight, recruits.points, recruits.committed, recruits.committedto, recruits.commitdate from recruits
LEFT JOIN recruits_college ON recruits.committedto = recruits_college.id
LEFT JOIN recruits_position ON recruits.position = recruits_position.id
LEFT JOIN recruits_class ON recruits.year_class = recruits_class.id
LEFT JOIN recruits_highschool ON recruits.school = recruits_highschool.id
LEFT JOIN recruits_town ON recruits.hometown = recruits_town.id
$wherelist $orderrowsby ";
$listrecs = mysql_query($query_listrecs, $floridaprospects) or die(mysql_error());
$row_listrecs = mysql_fetch_assoc($listrecs);
$totalRows_listrecs = mysql_num_rows($listrecs);
//echo $query_listrecs;
?>
No Recruits |
||||||||||||
|
|
||||||||||||
To Top | Total Recruits Displayed:
|
|
|
![]() |
|
Girls Basketball Recruiting News
Recruiting Sports