Edit one of multiple results

[linuxnewb]

$query = "SELECT * FROM table1 WHERE number=5";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
if ($num > 0)
{

echo "<b><center>Player's numbers</center></b>";
$i=0;

            while ($i < $num) {
               $playersname mysql_result($result,$i,"name");
               $anumber=mysql_result($result,$i,"number");
              i++;

echo " <tr><td> Name: </td><td colspan='3'>$playersname";
echo " <tr><td> Number:</td><td colspan='3'>$number<br>";

---

this will display:

Joe 5
James 5
Lil 5

How do I get it so I can just edit James 5 with an edit2.php?

If you need more info, please let me know

[LarsLai]

an easy way to do this: if you have an id for each player (if not you should change this anyway) you can dynamically create a formula in example with radiobuttons and the radiobuttons will get the value of the id.
echo "<form action='edit2.php' method=...>";

while ($i < $num) {
$playersname mysql_result($result,$i,"name");
$anumber=mysql_result($result,$i,"number");
$id=mysql_result($result,$i,"id");
i++;

echo "<input type='radio' name='somename' value='$id' />";
...
}

so you can choose between your results and with the id you can select one.
i`m sure there are better ways but easy does...