CODE
<center><b>Rank top 10</b></center>
<br>
<br>
<table align="center" border="1" color="white">
<tr bgcolor="#1B293D">
<td width="40"><font color="white">Position</td>
<td width="250"><font color="white">Name</td>
<td width="40"><font color="white">Rank</td>
</tr>
<?
include("dbconnect.php");
$sql = mysql_query("SELECT uname,rank,exp FROM members ORDER BY exp DESC LIMIT 10");
$i = 0;
while ($i < $sql){
while ($status=mysql_fetch_array($sql)){
$rank = $i+1;
echo "<tr bgcolor='#34547f'>";
echo "<td width='40'><font color='white'> ".$rank." </td>";
echo "<td width='130'><font color='white'><a href='index.php?action=charlookup.php&uname=".$status['uname']."'>".$status['uname']."<a></td>";
echo "<td width='80'><font color='white'> ".$status['rank']." </td>";
echo "</tr>";
++$i;
}
}
mysql_close();
?>
</table>
CODE
Fatal error: Maximum execution time of 30 seconds exceeded in /usr/home/100219/public_html/php/highscore.php on line 18
When opening the page it waits 30 seconds and then it displays the error and the highscores, so the highscore works fine, but it takes 30 seconds to load before displaying highscores
This post has been edited by TyForHelping: 19 Nov, 2006 - 02:46 AM
| 