Anonymous

<?php
require("dbConnection.php");
$dbLink = mysql_connect($dbHost, $dbUser, $dbPass);
@mysql_select_db(db14760_bands) or die( "Unable to select database");

$color1 = "#FFFFFF"; 
$color2 = "#CCCCCC"; 

$query="SELECT * FROM bands ORDER BY School";
$result=mysql_query($query);
$num=mysql_numrows($result);

mysql_close();
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>

<table width="437" cellpadding="2" cellspacing="0">
<tr>
    	<td width="279" align="left"><strong>School</strong></td>
    <td width="103" align="left"><strong>City</strong></td>
    <td width="41" align="left"><strong>State</strong></td>
  </tr>
    <?
    $i=0;
	while ($i < $num) {
	
	$id=mysql_result($result,$i,"id");
	$Name=mysql_result($result,$i,"Name");
	$School=mysql_result($result,$i,"School");
	$City=mysql_result($result,$i,"City");
	$State=mysql_result($result,$i,"State");
	$Director=mysql_result($result,$i,"Director");
	$AssistantDirector=mysql_result($result,$i,"Assistant Director(s)");
	$Drumline=mysql_result($result,$i,"Drumline");
	$Guard=mysql_result($result,$i,"Guard");
	$Website=mysql_result($result,$i,"Website");
	$i_color = ($i % 2) ? $color1 : $color2;
	
	echo '<pre>'; print_r($i); echo '</pre>';
	?>
    
	<tr bgcolor="<? echo $i_color?>">
    	<td align="left"><a href="dbtestresult.php?id=<?php echo $i['id'];?>"> <? echo $School;?> </a> </td>
      <td align="left"><? echo $City;?></td>
      <td align="left"><? echo $State;?></td>
  </tr>

<?
$i++;
}
?>
</table>


</body>
</html>