= 10) ? 4 : $check );
switch($check) {
case 1: return("st");
case 2: return("nd");
case 3: return("rd");
default: return("th");
} }
$sql="select * from score where login='$login';";
$result = mysql_query($sql) or die(mysql_error(). "test3");
if ($myrow = mysql_fetch_array($result)) {
$team=$myrow["team"];
$ind=$myrow["ind"];
$total=$myrow["total"];
$a='total';
$sql2="select count(*) as totale from score;";
$result2 = mysql_query($sql2) or die(mysql_error(). "test2");
$myrow = mysql_fetch_array($result2);
$totale=$myrow["totale"];
$sql2="select count(*) as totalu from score where $a>$total;";
$result2 = mysql_query($sql2) or die(mysql_error(). "test2");
$myrow = mysql_fetch_array($result2);
$place=$myrow["totalu"];
$place=$place+1;
echo "Welcome $login, in the Overall Contest you had $total points and are in $place".ordinal($place)." out of $totale";
echo " Click Here to view your picks in our scorer Click on any person below to view their picks ";
$sql5="select login, $a from score order by $a desc limit 0, 30;";
$result5 = mysql_query($sql5) or die(mysql_error());
echo " Top 30 Below";
$cols = 10;
//This is the counter
$i=0;
print '
Login
Points
';
$x=0;
$count=0;
while ($myrow5 = mysql_fetch_array($result5)) {
$ptotalpoints=$myrow5["$a"];
$login2=$myrow5["login"];
$count++;
if (($myrow5["$tot"])!=$x) {
$place=$count;
}
$x=($myrow5["$tot"]);
if ((is_int($i / $cols)) and $i!=0) {
echo "
';
$a='ind';
$sql2="select count(*) as totalu from score where $a>$ind;";
$result2 = mysql_query($sql2) or die(mysql_error(). "test2");
$myrow = mysql_fetch_array($result2);
$place=$myrow["totalu"];
$place=$place+1;
echo "Welcome $login, in the Individual Contest you had $ind points and are in $place".ordinal($place)." out of $totale";
echo " Click Here to view your picks in our scorer Click on any person below to view their picks ";
$sql5="select login, $a from score order by $a desc limit 0, 30;";
$result5 = mysql_query($sql5) or die(mysql_error());
echo " Top 30 Below";
$cols = 10;
//This is the counter
$i=0;
print '
Login
Points
';
$x=0;
$count=0;
while ($myrow5 = mysql_fetch_array($result5)) {
$ptotalpoints=$myrow5["$a"];
$login2=$myrow5["login"];
$count++;
if (($myrow5["$tot"])!=$x) {
$place=$count;
}
$x=($myrow5["$tot"]);
if ((is_int($i / $cols)) and $i!=0) {
echo "
';
$a='team';
$sql2="select count(*) as totalu from score where $a>$team;";
$result2 = mysql_query($sql2) or die(mysql_error(). "test2");
$myrow = mysql_fetch_array($result2);
$place=$myrow["totalu"];
$place=$place+1;
echo "Welcome $login, in the Team Contest you had $team points and are in $place".ordinal($place)." out of $totale";
echo " Click Here to view your picks in our scorer Click on any person below to view their picks ";
$sql5="select login, $a from score order by $a desc limit 0, 30;";
$result5 = mysql_query($sql5) or die(mysql_error());
echo " Top 30 Below";
$cols = 10;
//This is the counter
$i=0;
print '
Login
Points
';
$x=0;
$count=0;
while ($myrow5 = mysql_fetch_array($result5)) {
$ptotalpoints=$myrow5["$a"];
$login2=$myrow5["login"];
$count++;
if (($myrow5["$tot"])!=$x) {
$place=$count;
}
$x=($myrow5["$tot"]);
if ((is_int($i / $cols)) and $i!=0) {
echo "