Guest User

Untitled

a guest
Feb 21st, 2018
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.10 KB | None | 0 0
  1. <?PHP
  2. if ($db_found) {
  3.  
  4. $SQL = "SELECT * FROM Matches ORDER BY Week";
  5. $result = mysql_query($SQL);
  6.  
  7. while ($db_field = mysql_fetch_assoc($result)) {
  8.     $ptsA = $db_field['PtsA'];
  9.     $ptsB = $db_field['PtsB'];
  10.     $A_ID = $db_field['TeamA_Id'];
  11.     $B_ID = $db_field['TeamB_Id'];
  12.  
  13.     print '<td>' . $db_field['Week'] . '</td>';
  14.     print '<td>' . $db_field['M_Id'] . '</td>';
  15.    
  16.     $NameA_result = mysql_query("SELECT Name FROM Teams WHERE T_Id='$A_ID.'");
  17.     $TeamA_Name = mysql_fetch_row($NameA_result);
  18.     print '<td>'.$A_ID.'-' . $TeamA_Name . '</td>';
  19.    
  20.     print '<td>' . $db_field['PtsA'] . '</td>';
  21.    
  22.     $sql_NameB = "SELECT Name FROM Teams WHERE T_Id='".$B_ID."'";
  23.     $TeamB_Name = mysql_query($sql_NameB);
  24.     print '<td>'.$B_ID.'' . $TeamB_Name . '</td>';
  25.    
  26.     print '<td>' . $db_field['PtsB'] . '</td>';
  27.     if ($ptsA > $ptsB)
  28.         print '<td>' . $db_field['TeamA_Id'] . '</td>';
  29.     else if ($ptsA < $ptsB)
  30.         print '<td>' . $db_field['TeamB_Id'] . '</td>';
  31.     else if ($ptsA = $ptsB)
  32.         print '<td>Tie</td>';
  33.    
  34.     if ($db_field['Time']==0)
  35.         print '<td>AM</td>';
  36.     else if ($db_field['Time']==1)
  37.         print '<td>PM</td>';
  38.  
  39. ?>
Add Comment
Please, Sign In to add comment