I am trying to show team images instead of team names in a standings page that i have created. Images are stored on the server but i am unable to come up with the code that prints the image of the team. Here is my code.
Expand|Select|Wrap|Line Numbers
- <?php
- function ConferenceStandings ($conference)
- {
- include 'connect.php';
- $teamid = $_REQUEST["id"];
- // Connects to your Database
- $sql = "select *from season12 join teams WHERE season12 . team =teams . teamnameseason AND teams . conference ='$conference' ORDER BY `season12` . `P` DESC";
- $data = mysql_query($sql) or die(mysql_error());
- Print "<table width = 300>";
- Print "<th bgcolor=#C10000> # </th>";
- Print "<th bgcolor=#C10000> Team </th>";
- Print "<th bgcolor=#C10000> GP </th>";
- Print "<th bgcolor=#C10000> Pts </th>";
- $count++;
- while($info = mysql_fetch_array( $data ))
- {
- $wcount=$wcount+1;
- $teamnameseason = $info['teamnameseason'];
- Print "<tr>";
- if ($wcount == 9)
- {
- Print "<td>"?>
- <hr align="center" width="100%" size="1" color="#C10000" />
- <?php "</td> ";
- Print "<td>"?>
- <hr align="center" width="100%" size="1" color="#C10000" />
- <?php "</td> ";
- Print "<td>"?>
- <hr align="center" width="100%" size="1" color="#C10000" />
- <?php "</td> ";
- Print "<td>"?>
- <hr align="center" width="100%" size="1" color="#C10000" />
- <?php "</td> ";
- Print "<tr>";
- }
- Print "<td align = center>".$wcount. "</td> ";
- Print "<td align = center>".$info['teamnameseason'] . "</td> ";
- Print "<td align = center>".$info['GP'] . "</td> ";
- Print "<td align = center>".$info['P'] . "</td> ";
- }
- Print "</table>";
- include 'closedb.php';
- }
- print "<img src='images/logoest.gif' />";
- print "<br />";
- ConferenceStandings ("East");
- print "<br><br><br><br />";
- print "<img src='images/logowest.gif' />";
- ConferenceStandings ("West");
- ?>
As you can see teamnameseason is what is printing but i am looking for the image of the team that i have stored the link in a BLOB on the db...
Anyone able to give some advice?
Thanks in advance...