Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?PHP
- if ($db_found) {
- $SQL = "SELECT * FROM Matches ORDER BY Week";
- $result = mysql_query($SQL);
- while ($db_field = mysql_fetch_assoc($result)) {
- $ptsA = $db_field['PtsA'];
- $ptsB = $db_field['PtsB'];
- $A_ID = $db_field['TeamA_Id'];
- $B_ID = $db_field['TeamB_Id'];
- print '<td>' . $db_field['Week'] . '</td>';
- print '<td>' . $db_field['M_Id'] . '</td>';
- $NameA_result = mysql_query("SELECT Name FROM Teams WHERE T_Id='$A_ID.'");
- $TeamA_Name = mysql_fetch_row($NameA_result);
- print '<td>'.$A_ID.'-' . $TeamA_Name . '</td>';
- print '<td>' . $db_field['PtsA'] . '</td>';
- $sql_NameB = "SELECT Name FROM Teams WHERE T_Id='".$B_ID."'";
- $TeamB_Name = mysql_query($sql_NameB);
- print '<td>'.$B_ID.'' . $TeamB_Name . '</td>';
- print '<td>' . $db_field['PtsB'] . '</td>';
- if ($ptsA > $ptsB)
- print '<td>' . $db_field['TeamA_Id'] . '</td>';
- else if ($ptsA < $ptsB)
- print '<td>' . $db_field['TeamB_Id'] . '</td>';
- else if ($ptsA = $ptsB)
- print '<td>Tie</td>';
- if ($db_field['Time']==0)
- print '<td>AM</td>';
- else if ($db_field['Time']==1)
- print '<td>PM</td>';
- ?>
Add Comment
Please, Sign In to add comment