I got the following code:
我得到以下代码:
<?php
require('connect.php');
if(isset($_GET['region'])) {
$region = mysql_real_escape_string($_GET['region']);
if ($region == "eu") {
$rows = mysql_fetch_array(mysql_query("SELECT * FROM `daily_leaderboard_eu`"));
} elseif ($region == "na") {
$rows = mysql_fetch_array(mysql_query("SELECT * FROM `daily_leaderboard_na`"));
}
} else {
$rows = mysql_fetch_array(mysql_query("SELECT * FROM `daily_leaderboard_eu`"));
}
?>
<table>
<tr>
<td>Rank</td>
<td>Points</td>
</tr>
<tr>
<?
if(empty($rows)){
echo '<td colspan="5">We are unable to provide data at the moment!</td>';
} else {
foreach($rows as $row){?>
<td><?=$row['rank']?></td>
<td><?=$row['points']?></td>
<?}
}
?>
</tr>
</table>
<?php
r