rendered paste body<?php
$mysql_table = "cp_roster";
require_once ("required.inc.php");
$result = MYSQL_QUERY("SELECT * FROM $mysql_table ORDER BY type ASC LIMIT 6") or die (mysql_error());
$rows = mysql_num_rows($result);
if ($rows == "0") {
echo "<b>No Members in the roster database table.</b>";
} else {
echo '<table border="0" align="center" cellpadding="0" cellspacing="3">';
$i = 0;
while ($mysql=mysql_fetch_array($result)) {
$i++;
if ($i == 1) echo '<tr bgcolor="#2A3133">';
?>
<td style="border: 1px solid rgb(42,49,52)">
<a href="index.php?id=csroster&roster_id=<?=$mysql[roster_id]?>" onMouseOver="changetext('<?=checkContent($mysql[alias]);?>'); return true;" onMouseOut="changetext('Select a Member to View')" target="_parent">
<img src="<?=$imagefilepath . 'rosterpic' . $mysql[roster_id] . '.' . $mysql['imagetype']?>" width="45" height="45" border="0"></img></a></td>
<?
if ($i == 3) {
echo '</tr>';
$i = 0;
}
}
if ($i != 0) echo '</tr>';
echo '</table><div align="center" id="descriptions">Select a Member to View</div>';
}
?>