i need to make a "delete" button...

[vintagestars]

Ok, i have this weblog:

<?
include("db_fns.php");
$sql = "SELECT * FROM weblog";
$result = mysql_query($sql,$db) or die("Unable to download the weblog content <br/>".mysql_error());

do{
	echo "<span class='heading'>". $row["headline"] ."</span><br /><br />";
	echo "<span class='story'>". $row["story"] ."</span><br /><br />";
	echo "<span class='lastline'>Posted by <a href='mailto:". $row["author_email"] ."'>". $row["author"] ."</a> on ". $row["date"] ." at ". $row["time"] ."</span><br><br>";
}while($row = mysql_fetch_array($result));

?>

and this shows the posts. But how can i add a "delete button" using the delete or unlink() function?? I want to be able to select a row (aka: post) and then delete it using the post's ID ($ID)

Please help!
-Carrie
vintagestars.com

[buraks78]

in the do loop;

echo "<a href='delete.php?id=" . $id . "'>delete</a>";

of

echo "<form action='delete.php' method='post'><input type='submit' value='delete'><input type='hidden' value='" . $id . "'></form>";

this will print a "delete" link or button next to each row

and delete.php is obvious

 
<?php
//connect to database
//get id in querystring
//delete row using id
//delete file if thereis one
//redirect to the weblog list again
?>

[Nabster]

Simply add to the end of the link dynamically viewpost.php?ID=3,
then have it go to a page or section of a page that contains your database connection, then just use this sql query:

$sql2 = "DELETE FROM $table_name WHERE ID = '$ID'";