1#@!#!123s

: / home / stickain / www / itosu-ryu.us /
Filename : bbelts.php
back
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>

</head>


<body style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" link="#0000ff">

<br>

<?php include 'body.inc';
include './includes/dbinfo.php';
if($site=="dp"){$site2="Dana Point";}
if($site=="occ"){$site2="Orange Coast College";}
if($site=="sc"){$site2="San Clemente";}
?><?php echo "<center><table border=1><td><center>Shodan</center><tr><td>";
$count="1";
$query = "SELECT * FROM kai_members Where `rank`='1' ORDER BY l_name";
$result = mysql_query($query);
$count2=mysql_num_rows($result);
if($count2>12){$count2=ceil($count2 / 3);}
if($count2>6){$count2=ceil($count2 / 2);}
while($row = mysql_fetch_array($result)) {
if($row[picture]==""){$row[picture]="nophoto.gif";}
if($count == 1){echo "<center><table border=1>";}
echo "<td valign='top'><center><img src=./bbphotos/$row[picture]><br>$row[f_name] $row[l_name]</center>";
$count = $count + 1;
// echo "<b>$row[headline] </b><br>";
if($count >$count2){
echo "<tr>";
$count = 1;
}
}
echo "</table></center>";
echo "</table></center>";
?><?php echo "<center><table border=1><td><center>Nidan</center><tr><td>";
$count="1";
$query = "SELECT * FROM kai_members WHERE `rank`='2' ORDER BY l_name";
// $query = "SELECT * FROM kai_members WHERE Length( picture ) > 0 and `rank`='2' ORDER BY l_name";
$result = mysql_query($query);
$count2=mysql_num_rows($result);
if($count2>6){$count2=ceil($count2 / 2);}
while($row = mysql_fetch_array($result)) {
if($row[picture]==""){$row[picture]="nophoto.gif";}
if($count == 1){echo "<center><table border=1>";}
echo "<td valign='top'><center><img src=./bbphotos/$row[picture]><br>$row[f_name] $row[l_name]</center>";
$count = $count + 1;
// echo "<b>$row[headline] </b><br>";
if($count > $count2){
echo "<tr>";
$count = 1;
}
}
echo "</table></center>";
echo "</table></center>";
?><?php echo "<center><table border=1><td><center>Sandan</center><tr><td>";
$count="1";
$query = "SELECT * FROM kai_members WHERE `rank`='3' ORDER BY l_name";
$result = mysql_query($query);
$count2=mysql_num_rows($result);
if($count2>6){$count2=ceil($count2 / 2);}
while($row = mysql_fetch_array($result)) {
if($row[picture]==""){$row[picture]="nophoto.gif";}
if($count == 1){echo "<center><table border=1>";}
echo "<td valign='top'><center><img src=./bbphotos/$row[picture]><br>$row[f_name] $row[l_name] Sensei</center>";
$count = $count + 1;
// echo "<b>$row[headline] </b><br>";
if($count > $count2){
echo "<tr>";
$count = 1;
}
}
echo "</table></center>";
echo "</table></center>";
?><?php echo "<center><table border=1><td><center>Yondan</center><tr><td>";
$count="1";
$query = "SELECT * FROM kai_members WHERE `rank`='4' ORDER BY l_name";
// $query = "SELECT * FROM kai_members WHERE Length( picture ) > 0 and `rank`='4' ORDER BY l_name";
$result = mysql_query($query);
while($row = mysql_fetch_array($result)) {
if($row[picture]==""){$row[picture]="nophoto.gif";}
if($count == 1){echo "<center><table border=1>";}
echo "<td valign='top'><center><img src=./bbphotos/$row[picture]><br>$row[f_name] $row[l_name] Sensei</center>";
$count = $count + 1;
// echo "<b>$row[headline] </b><br>";
if($count == 6){
echo "<tr>";
$count = 1;
}
}
echo "</table></center>";
echo "</table></center>";
?><?php echo "<center><table border=1><td><center>Godan</center><tr><td>";
$count="1";
$query = "SELECT * FROM kai_members WHERE `rank`='5' ORDER BY l_name DESC";
// $query = "SELECT * FROM kai_members WHERE Length( picture ) > 0 and `rank`='4' ORDER BY l_name";
$result = mysql_query($query);
while($row = mysql_fetch_array($result)) {
if($row[l_name]=="Crockett"){$chief="<br>Chief Instructor";}else{$chief="";}
if($row[picture]==""){$row[picture]="nophoto.gif";}
if($count == 1){echo "<center><table border=1>";}
echo "<td valign='top'><center><img src=./bbphotos/$row[picture]><br>$row[f_name] $row[l_name] Sensei" . $chief . "</center>";
$count = $count + 1;
// echo "<b>$row[headline] </b><br>";
if($count == 6){
echo "<tr>";
$count = 1;
}
}
echo "</table></center>";
echo "</table></center>";
?>
</body>
</html>