Weird delete problem - the code deletes everything but selected record

[Korona]

Hi, I am making a php/mysql page and everything works but delete function. When I hit "delete" link at a row, the page doesn't delete that row but next or previous one.

 

here's the code:

 

  <?php

 

    include("ini.php");

 

    $result = mysql_query("SELECT id, playersname, age, address FROM mytable ORDER BY id ASC",$connect);

 

    echo "<table>";

 

    while($myrow = mysql_fetch_array($result))

    {

 

    $id = $myrow["id"];

    $playersname = $myrow["playersname"];

    $age = $myrow["age"];

    $address = $myrow["address"];

 

 

    if ($task=="del") {

 

    $sql = "DELETE FROM mytable WHERE id=$id";

    $result = mysql_query($sql);

    echo "Row deleted!";

                      }

 

    echo "<tr><td><p><a href=\"player.php?id=$id\">$playersname</a></p></td><td><p>$age  </p></td><td><p>$address</p></td><td><p><a href=\"playerslist.php?id=$id&task=del\">Delete</a></p></td></tr>";

    }

 

 

    echo "</table>";

 

    ?>

 

Thank you in advance for help

 

 

 

[kickstart]

Hi

 

You do not appear to be checking any passed in variables to determine whether you are doing a delete or what id to delete.

 

All the best

 

Keith