mysql_connect('localhost','username','password');
mysql_select_db('db');
if(empty($_GET['id']))
{
$query = mysql_query('SELECT * FROM news ORDER BY id DESC');
while($output = mysql_fetch_assoc($query))
echo $output['subject'].' » Delete
';
}
else
{
$id = $_GET['id'];
mysql_query("DELETE FROM news WHERE id = $id LIMIT 1");
mysql_query("DELETE FROM newscomments WHERE link = $id");
echo 'News Deleted.';
}
?>