diff options
| author | Matthijs Kuiper <info@matthijskuiper.nl> | 2018-01-14 20:08:50 +0100 |
|---|---|---|
| committer | Matthijs Kuiper <info@matthijskuiper.nl> | 2018-09-01 11:48:28 +0200 |
| commit | 7e5c50603cbe1307d68a2b5b8ee14409e15a9dcb (patch) | |
| tree | 0fff0499b4d94f8ed2e13d72bfd97dec51cd283e /html/pages/report_cb.php | |
| parent | 4d21dfcac97fd02c186bb3ce4085275b36e3790e (diff) | |
Update to mysqli
Diffstat (limited to 'html/pages/report_cb.php')
| -rw-r--r-- | html/pages/report_cb.php | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/html/pages/report_cb.php b/html/pages/report_cb.php index 50eb5d4..97493eb 100644 --- a/html/pages/report_cb.php +++ b/html/pages/report_cb.php @@ -28,16 +28,16 @@ echo'<table> <td width="50%" class="grey">';
$sql_rteam = "SELECT p.id, pi.name FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND matchid = $id AND team = 0 ORDER BY pi.name ASC";
-$q_rteam = mysql_query($sql_rteam);
-while ($r_rteam = mysql_fetch_array($q_rteam)) {
+$q_rteam = mysqli_query($GLOBALS["___mysqli_link"], $sql_rteam);
+while ($r_rteam = mysqli_fetch_array($q_rteam)) {
echo''.$r_rteam[name].'<br />';
}
echo'</td>
<td width="50%" class="grey">';
$sql_bteam = "SELECT p.id, pi.name FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND matchid = $id AND team = 1 ORDER BY pi.name ASC";
-$q_bteam = mysql_query($sql_bteam);
-while ($r_bteam = mysql_fetch_array($q_bteam)) {
+$q_bteam = mysqli_query($GLOBALS["___mysqli_link"], $sql_bteam);
+while ($r_bteam = mysqli_fetch_array($q_bteam)) {
echo''.$r_bteam[name].'<br />';
}
echo'</td></tr></table><br>';
@@ -120,8 +120,8 @@ IF ($stage == "2") { $sql_rteam = "SELECT p.id, pi.name FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND matchid = $id AND team = 0 ORDER BY pi.name ASC";
- $q_rteam = mysql_query($sql_rteam);
- while($r_rteam = mysql_fetch_array($q_rteam)) {
+ $q_rteam = mysqli_query($GLOBALS["___mysqli_link"], $sql_rteam);
+ while($r_rteam = mysqli_fetch_array($q_rteam)) {
echo'<tr>
<td class="grey">'.$r_rteam[name].'</td>
@@ -142,8 +142,8 @@ IF ($stage == "2") { $sql_bteam = "SELECT p.id, pi.name FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND matchid = $id AND team = 1 ORDER BY pi.name ASC";
- $q_bteam = mysql_query($sql_bteam);
- while($r_bteam = mysql_fetch_array($q_bteam)) {
+ $q_bteam = mysqli_query($GLOBALS["___mysqli_link"], $sql_bteam);
+ while($r_bteam = mysqli_fetch_array($q_bteam)) {
echo'<tr>
<td class="grey">'.$r_bteam[name].'</td>
|