Ok here is my problem!
On this page I am trying to get the 2 teams to have their logo appear, NOT there 3 letter team, NYY, TEX, etc.
I am not sure of the proper syntax code I put in. Here is the php code source!
Code:<?php $generate = ''; $result = mysql_query("SELECT * FROM boxscoreaway ORDER BY 'id' ASC"); $away = mysql_fetch_array($result); $result = mysql_query("SELECT * FROM boxscorehome ORDER BY 'id' ASC"); $home = mysql_fetch_array($result); // the away team just began $generate .= '<tr style="background-color:eeeeee"> <td width="254"><table width="100%" border="0"> <tr> <td id="team" width="20%">' . $away['team'] . '</td> <td align="left" width="80%">'; // once more, those math classes for logic comes in hand, but this logic is too easy // if $away team had more runs, then show that the winner was the $away team if( $away['R'] > $home['R'] ) { $generate .= '<img src="http://robbyzworld.com/personal/images/sports/nyy/winner.gif" />'; } $generate .= '</td> </tr> </table></td> <td width="35">' . $away['R'] . '</td> <td width="35">' . $away['H'] . '</td> <td width="35">' . $away['E'] . '</td> </tr>'; // the away team just ended // the home team just began $generate .= '<tr style="background-color:eeeeee"> <td width="254"><table width="100%" border="0"> <tr> <td id="team" width="20%">' . $home['team'] . '</td> <td align="left" width="80%">'; // but, if the $home team had more runs, then show that the home team won. if( $away['R'] < $home['R'] ) { $generate .= '<img src="http://robbyzworld.com/personal/images/sports/nyy/winner.gif" />'; } $generate .= '</td> </tr> </table></td> <td width="35">' . $home['R'] . '</td> <td width="35">' . $home['H'] . '</td> <td width="35">' . $home['E'] . '</td> </tr>'; // end the home team just ended echo $generate; ?>




Reply With Quote