color coding a table ?

Mark_Nordstrom

heres the code.

          <?php require_once('Connections/nba.php'); ?>
          <?php
mysql_select_db($database_nba, $nba);
$query_b = "SELECT r.team_id AS tid , t.team_name AS tn, r.points AS R, r.benchscoring AS BS, 100*r.fieldgoals AS FG, r.fieldgoalp AS FP, 100*r.threepointfg AS tp, r.threepointfgP AS TPP, 100*r.freethrows AS FT, r.freethrowP AS FTP, r.Rebounds AS REB, r.Blocks AS B, r.Steals AS S, r.Assists AS A FROM `result` AS r, team AS t WHERE r.game_id= $id AND r.team_id = t.team_id ORDER BY r.points DESC";
$b = mysql_query($query_b, $nba) or die(mysql_error());
$row_b = mysql_fetch_assoc($b);
$totalRows_b = mysql_num_rows($b);

mysql_select_db($database_nba, $nba);
$query_stats = "SELECT * FROM stats WHERE game_id= $id ";
$stats = mysql_query($query_stats, $nba) or die(mysql_error());
$row_stats = mysql_fetch_assoc($stats);
$totalRows_stats = mysql_num_rows($stats);

?>
          <br>
          <br>
          <strong>Team Totals:</strong> <br>
          <br>
          <table border="1" cellpadding="1" cellspacing="0" bordercolor="#000000">
            <tr> 
              <td bgcolor="#333333" height="14"><strong><font color="#FFFFFF">Team</font></strong></td>
              <td bgcolor="#333333"><strong><font color="#FFFFFF">Score</font></strong></td>
              <td bgcolor="#333333"><strong><font color="#FFFFFF">FG % </font></strong></td>
              <td bgcolor="#333333"><strong><font color="#FFFFFF">3p % </font></strong></td>
              <td bgcolor="#333333"><strong><font color="#FFFFFF">FT % </font></strong></td>
              <td bgcolor="#333333"><strong><font color="#FFFFFF">Rebs</font></strong></td>
              <td bgcolor="#333333"><strong><font color="#FFFFFF">Blocks</font></strong></td>
              <td bgcolor="#333333"><strong><font color="#FFFFFF">Steals</font></strong></td>
              <td bgcolor="#333333"><strong><font color="#FFFFFF">Assist</font></strong></td>
            </tr>
            <?php do { ?>
            <tr> 
              <td bgcolor="#ffffff"><?php echo $row_b['tn']; ?></td>
              <td bgcolor="#ffffff"><?php echo $row_b['R']; ?></td>
              <td bgcolor="#ffffff"><?php echo $row_b['FG']; ?></td>
              <td bgcolor="#ffffff"><?php echo $row_b['tp']; ?></td>
              <td bgcolor="#ffffff"><?php echo $row_b['FT']; ?></td>
              <td bgcolor="#ffffff"><?php echo $row_b['REB']; ?></td>
              <td bgcolor="#ffffff"><?php echo $row_b['B']; ?></td>
              <td bgcolor="#ffffff"><?php echo $row_b['S']; ?></td>
              <td bgcolor="#ffffff"><?php echo $row_b['A']; ?></td>
            </tr>
            <?php } while ($row_b = mysql_fetch_assoc($b)); ?>
          </table>
                            <p><br>
            <strong>Individual Player Stats: </strong> </p>

      <table border="1" cellpadding=1" cellspacing="0" bordercolor="#000000">
        <tr> 
          <td nowrap bgcolor="#333333"><div align="center"><strong><font color="#FFFFFF">Name</font></strong></div></td>
          <td nowrap bgcolor="#333333"><div align="center"><strong><font color="#FFFFFF">Pts</font></strong></div></td>
          <td nowrap bgcolor="#333333"><div align="center"><strong><font color="#FFFFFF">Min</font></strong></div></td>
          <td nowrap bgcolor="#333333"><div align="center"><strong><font color="#FFFFFF">FGM</font></strong></div></td>
          <td nowrap bgcolor="#333333"><div align="center"><strong><font color="#FFFFFF">FGA</font></strong></div></td>
          <td nowrap bgcolor="#333333"><div align="center"><strong><font color="#FFFFFF">FG 
              % </font></strong></div></td>
          <td nowrap bgcolor="#333333"><div align="center"><strong><font color="#FFFFFF">3pm</font></strong></div></td>
          <td nowrap bgcolor="#333333"><div align="center"><strong><font color="#FFFFFF">3pa</font></strong></div></td>
          <td nowrap bgcolor="#333333"><div align="center"><strong><font color="#FFFFFF">3%</font></strong></div></td>
          <td nowrap bgcolor="#333333"><div align="center"><strong><font color="#FFFFFF">FTM</font></strong></div></td>
          <td nowrap bgcolor="#333333"><div align="center"><strong><font color="#FFFFFF">FTA</font></strong></div></td>
          <td nowrap bgcolor="#333333"><div align="center"><strong><font color="#FFFFFF">FT% 
              </font></strong></div></td>
          <td nowrap bgcolor="#333333"><div align="center"><strong><font color="#FFFFFF">OReb 
              </font></strong></div></td>
          <td nowrap bgcolor="#333333"><div align="center"><strong><font color="#FFFFFF">DReb</font></strong></div></td>
          <td nowrap bgcolor="#333333"><div align="center"><strong><font color="#FFFFFF">Reb</font></strong></div></td>
          <td nowrap bgcolor="#333333"><div align="center"><strong><font color="#FFFFFF">Blk</font></strong></div></td>
          <td nowrap bgcolor="#333333"><div align="center"><strong><font color="#FFFFFF">Stl</font></strong></div></td>
          <td nowrap bgcolor="#333333"><div align="center"><strong><font color="#FFFFFF">Ast</font></strong></div></td>
          <td nowrap bgcolor="#333333"><div align="center"><strong><font color="#FFFFFF">TOs</font></strong></div></td>
          <td nowrap bgcolor="#333333"><div align="center"><strong><font color="#FFFFFF">FLs</font></strong></div></td>
        </tr>
        <?php do { ?>
        <tr> 
          <td nowrap bgcolor="#ffffff"><div align="center"><?php echo $row_stats['Name']; ?></div></td>
          <td nowrap bgcolor="#ffffff"><div align="center"><?php echo $row_stats['Points']; ?></div></td>
          <td nowrap bgcolor="#ffffff"><div align="center"><?php echo $row_stats['Minutes']; ?></div></td>
          <td nowrap bgcolor="#ffffff"><div align="center"><?php echo $row_stats['FGM']; ?></div></td>
          <td nowrap bgcolor="#ffffff"><div align="center"><?php echo $row_stats['FGA']; ?></div></td>
          <td nowrap bgcolor="#ffffff"><div align="center"><?php echo $row_stats['FGPercent']; ?></div></td>
          <td nowrap bgcolor="#ffffff"><div align="center"><?php echo $row_stats['threepm']; ?></div></td>
          <td nowrap bgcolor="#ffffff"><div align="center"><?php echo $row_stats['threepa']; ?></div></td>
          <td nowrap bgcolor="#ffffff"><div align="center"><?php echo $row_stats['threeP']; ?></div></td>
          <td nowrap bgcolor="#ffffff"><div align="center"><?php echo $row_stats['FTM']; ?></div></td>
          <td nowrap bgcolor="#ffffff"><div align="center"><?php echo $row_stats['FTA']; ?></div></td>
          <td nowrap bgcolor="#ffffff"><div align="center"><?php echo $row_stats['FTPercent']; ?></div></td>
          <td nowrap bgcolor="#ffffff"><div align="center"><?php echo $row_stats['Orebounds']; ?></div></td>
          <td nowrap bgcolor="#ffffff"><div align="center"><?php echo $row_stats['Drebounds']; ?></div></td>
          <td nowrap bgcolor="#ffffff"><div align="center"><?php echo $row_stats['Rebounds']; ?></div></td>
          <td nowrap bgcolor="#ffffff"><div align="center"><?php echo $row_stats['Block']; ?></div></td>
          <td nowrap bgcolor="#ffffff"><div align="center"><?php echo $row_stats['Steal']; ?></div></td>
          <td nowrap bgcolor="#ffffff"><div align="center"><?php echo $row_stats['Assist']; ?></div></td>
          <td nowrap bgcolor="#ffffff"><div align="center"><?php echo $row_stats['Turnovers']; ?></div></td>
          <td nowrap bgcolor="#ffffff"><div align="center"><?php echo $row_stats['Fouls']; ?></div></td>
        </tr>
        <?php } while ($row_stats = mysql_fetch_assoc($stats)); ?>
      </table>
                        <?php
mysql_free_result($b);

mysql_free_result($stats);
?>

now what i need to do is. For team make the table backround gray.

For opponent make it white.

But there has to be a IF clause because the stats for this are queued seperated but the team name is the same as the team or opponent.

So IF t.team_name=$row_stats['team']; background has to =gray

ELSE =white or something.

Mark_Nordstrom

anyone got any ideas ?

Shrike

Hmm I'm a bit confused as to what you want. Set the current team name to a variable and check it again on the next pass?

Mark_Nordstrom

ok in all that php code there. There are 2 queues. Each one has 2 team names. I want it to do this. Check the name of 1 team match it to the other then make the backround with the players from that team gray. Then do it for the other team and make it white.

Shrike

Sorry if I'm being a bit dim here, which piece of data in the database links a player to a team?

Mark_Nordstrom

team names are from boxscores.

fields are

team
opponent
score
score1

epimeth

epimeth

or, at the begining of every loop:

$bgcolor = (t.team_name==$row_stats['team'])?'gray':'white';
...
...
...
<td bgcolor="<?=$bgcolor?>">...</td>