Jump to content

Weird delete problem - the code deletes everything but selected record


Korona

Recommended Posts

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

 

 

 

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.