<td height="30" colspan="2" align="left" valign="bottom"><a href="players.php?id=<?=$row[id]--?>" ><img src="img/arrow_left.gif" alt="previous" width="13" height="10" border="0"></a></td>
<td height="30" colspan="2" align="right" valign="bottom"><a href="players.php?id=<?=$row[id]++?>" ><img src="img/arrow_right.gif" alt="next" width="13" height="10" border="0"></a></td>
                                           
<?php
$db = mysql_connect($dbnfo[host],$dbnfo[username],$dbnfo[password]);
mysql_select_db ($dbnfo[db_name]) or die ("Cannot connect to database");

if ($_GET['id'])

{
$query = "SELECT * FROM players WHERE id = $_GET[id]";
$result = mysql_query($query);
while($r=mysql_fetch_array($result))
{
$id=$r["id"];
}


} else {
$query = "SELECT * FROM players WHERE id = 1";}
{
$id=$r["id"];
echo $id;
}
}
?>