Name | Position | | |
0)
{
$theplayers = mysql_result($result,0,"players");
$theself = mysql_result($result,0,"self");
$theplayerid = mysql_result($result,0,"playerid");
if ($theplayers == 1)
{
$sql = "select id,name,position from players";
}
else
{
$sql = "select id,name,position from players where id=$theplayerid";
}
}
$db = mysql_connect("$host","$user","$password");
mysql_select_db("$dbname",$db);
$result = mysql_query($sql);
$num = mysql_numrows($result);
$ind = 0;
while ($ind < $num )
{
$theid = mysql_result($result,$ind,"id");
$thename = mysql_result($result,$ind,"name");
$theposition = mysql_result($result,$ind,"position");
echo "";
echo "$thename | ";
echo "$theposition | ";
echo "[Edit] | ";
echo "[Delete] | ";
echo " ";
$ind++;
}
?>
|