View Google Videos on this page or click here for more.
";
$c=1;
while ($c <=3){ //Once for each Coloumn (PART 1 - the Titles)
if($p==1){
if($c==1){$titletext = "Overachievers";}
if($c==2){$titletext = "Most Popular";}
if($c==3){$titletext = "Highly Criticized";}
}else{
if($c==1){$titletext = "Underachievers";}
if($c==2){$titletext = "Least Popular";}
if($c==3){$titletext = "Needs Grading";}
}
?>
|
|
";
/////////////////////////////////// TOP COMPLETE ///////////////////////////////
$r=1;
while ($r <=3){
if($r==1){$sortby = "grade";}
if($r==2){$sortby = "views";}
if($r==3){$sortby = "votes";}
$query = "SELECT video, title, picurl, description, length, " . $sortby . " FROM video ORDER BY " . $sortby . " ". $sortorder . " LIMIT 0,5";
if($r==1){$oa_result=mysql_query($query);}
if($r==2){$mp_result=mysql_query($query);}
if($r==3){$hc_result=mysql_query($query);}
$r++;
}
$x=1;
while ($x <=3){
echo "";
$y=1;
while ($y <=3){
?>
>
|
";
$x++;
}
//////////////////////////////////// MID COMPLETE ////////////////////////////
$p++;
if($p==2){
?>
|