Menu
Hey everyone…
I’m building a website for local sports in my community and will be doing schedules.
High School sports usually have three different teams in the same sport, (9, JV, V). I would like to highlight all the Varsity (v) games with a different font color OR table background.
[code=php]<table width=”100%”>
<tr>
<td><strong>Date</strong></td><td><strong>Squad</strong></td><td><strong>Opponent</strong></td><td><strong>Time/Varsity Scores</strong></td><td><strong>Home/Away</strong></td>
</tr>
<?php
// Connects to your Database
mysql_connect(“NOTHING TO SEE HERE”, “OR HERE”, “OR HERE”) or die(mysql_error());
mysql_select_db(“OR HERE”) or die(mysql_error());
$data = mysql_query(“SELECT * FROM events WHERE Sport=’$sport’ and Team=’$team'”)
or die(mysql_error());
while($info = mysql_fetch_array( $data ))
{
Print “<tr><td>”.$info[‘CleanDate’] . “</td><td>”.$info[‘Teams’] . “</td><td>”.$info[‘Opponent’] . “</td><td>”.$info[‘TimeScore’] . “</td><td>”.$info[‘HomeAway’] . “</td></tr>”;
}
?></table>