How would I go about deleting onw row from a MySQL table? here's the info:

Table: news
Setup: Id=Auto-incrementing

that's basically all the info you need... i've tried it several times but I get the same result... deletes the whole thing... any help would be apreciated

http://dev.mysql.com/doc/mysql/en/delete.html

thanks

Still didn't work

To delete a row is very similar to doing a select. You add a where clause to specify which rows you want to delete, usually using the primary key so that you delete one specific row:

DELETE FROM yourtable WHERE id = 7;

Will just delete that row with id 7.

But I dont have the ID, here, ill give you the code:

PHP Code:

  $qu = "SELECT * FROM news ORDER BY `id` DESC LIMIT 10";
  $res = mysql_query($qu);
  if (mysql_num_rows($res) == 0) {
    echo "There is no news!";
  }
  else {
    while ($ro = mysql_fetch_array($res)) {
        $nam = $ro["name"];
      $msg = $ro["news"];
      $id = $ro["id"];
      echo $nam . ":";
      echo " " . $msg;
      if ($session->isAdmin()) {
      echo "<div align=\"right\"><a href=\"proc3.php\">Delete post</a></div>";
      }
      echo "<hr align=\"left\" width=75% color=blue>";
    } 


and here's proc3.php:

PHP Code:

<?
include("include/session.php");
  $query = "DELETE FROM `news` WHERE `id` = '$id' LIMIT 1";
  mysql_query($query) or die("A mysql error has occurred: " . mysql_error());
return $query;
  echo "<META HTTP-EQUIV=\"Refresh\" CONTENT=\"1; URL=main.php\">";
?>

What you need to do is when you generate the page, put the ID of the news item into the delete link:

PHP Code:

echo "<a href = \"proc3.php?ID=$id\">Delete This Post</a>"; 


Then on proc3.php you can retrieve the ID number from the $_GET array that PHP provides to store the values of variables in the URL:

PHP Code:

$id = $_GET['id'];
mysql_query("DELETE FROM news WHERE id = $id LIMIT 1"); 


Each link has a different id number in it, and will cause that post to be deleted.

Can I just say something?

You are using a meta refresh to relocate, which is a bad move if you wish popularity from SE's. Have you looked at the header function in php?

thanks for the suggestion Gaffer, it's been noted, but It still doesn't seem to want to work Oberon, I tried the code and it processes it, but it doesn't delete, by the way, it gets the right ID i've checked that,

EDIT: nevermind, i got it working, I had to change the $_GET['id'] to $_GET['ID']... my host is very strict about capitals