Deleting from Mysql, ids go the same.

[killaklown]

When i click on Delete, it will delete the row from the mysql, but it will change all the ids to the same (as the one i deleted) and the row i deleted still shows up. I would need to refresh the page to change the ids back to their original ones and to have the row i deleted to dissapear. How can i do this without pressing the refresh button?

The code is:

    while ($row = mysql_fetch_array($rs))
    {
        $title = $row["title"];
        $url = $row["url"];
        $id = $row["id"];
        $category = $row["category"];
		$description = $row["description"];
		
if(isset($_GET["delete"])) {
	$id = $_GET["delete"];
	mysql_query("DELETE FROM tutorials WHERE id='$id' LIMIT 1");
}	
echo("<tr><td>$id</td><td>$title</td><td>$category</td><td>$description</td><td>Edit | <a href=\"tutorials.php?delete=$id\">Delete</a></td></tr>");
    }

Edit: i just fixed it so they dont all change to the same id (changed the $id in the isset to $tid) But how can i automaticaly refresh it?


Edit: i got it to work.

 

[OK]

    while ($row = mysql_fetch_array($rs))
    {
        $title = $row["title"];
        $url = $row["url"];
        $id = $row["id"];
        $category = $row["category"];
		$description = $row["description"];
		
if(isset($_GET["delete"])) {
	$sid = $_GET["delete"];
	mysql_query("DELETE FROM tutorials WHERE id='$sid' LIMIT 1");
}	
echo("<tr><td>$id</td><td>$title</td><td>$category</td><td>$description</td><td>Edit | <a href=\"tutorials.php?delete=$id\">Delete</a></td></tr>");
    }

Try that...

You overwrite $id and therefore remains constant. Try to change to $sid or some other variable not in use.

quote : Edit: i just fixed it so they dont all change to the same id (changed the $id in the isset to $tid) But how can i automaticaly refresh it? [[yea im lazy :D]]

use the header function.
header("Location: http://www.example.com/pageyouwanttogotto");

 

[baxter]

I think this will be what your looking for: just changed it to make sure the id == the deleted row id. and continued the loop if it did so it doesn't print it out after deleting it. Hope that helps

while ($row = mysql_fetch_array($rs))
{
    $title = $row["title"];
    $url = $row["url"];
    $id = $row["id"];
    $category = $row["category"];
	$description = $row["description"];
		
if(intval($_GET['delete']) == $id) {
	mysql_query("DELETE FROM tutorials WHERE id='$id' LIMIT 1");
	continue;
}
	
    echo("<tr><td>$id</td><td>$title</td><td>$category</td><td>$description</td><td>Edit | <a href=\"tutorials.php?delete=$id\">Delete</a></td></tr>");
}

EDIT: missed closing bracket in intval :P