php中的SQL代码没有删除记录

Question

First: Yes mysqli is awesome, i cannot use it for this.

now: I wrote a code that once called should delete a specific record, it executes, no errors, and output message even comes out but it does not delete the record.

why? How can I fix this?

I see no mistake so far:

<?php
if(isset($_POST['Delete']))
{ 
 $connection = mysql_connect("Deleted login info");

 // Check connection
 if (!$connection)
 {
    //echo "Connection failed: " . mysql_connect_error();
 }      
 else
 { 
   //select a database
   $dbName="Katz";
   $db_selected = mysql_select_db($dbName, $connection); 
        
   //confirm connection to database
   if (!$db_selected)
   {
     die ('Can\'t use $dbName : ' . mysql_error());
   }            
   else if ($_POST[KittenID]=='')
   {    
     $OutputMessage = 'Must add a Kitten-ID';
   }                        
   else
   {//exeption else     
     {//main else
        $sql = "DELETE FROM Kittenzz WHERE KittenID='$_POST[KittenID]";

        $retval = mysql_query($sql, $connection);
        if(!$retval )
        {
            $OutputMessage = 'RECORD DOES NOT ALLOW DELETION';
        }
        $OutputMessage = 'RECORD DELETED';
                
        mysql_close($connection);            
      }//main else
    }//exception else
  } 

  mysql_close($connection);
}
            
?>

Could I get a fresh look from someone?

</div>

Answer 1

You missed one single quote in your query.

 $sql = "DELETE FROM Kittenzz
         WHERE KittenID='$_POST[KittenID]";

Please try this :

 $sql = "DELETE FROM Kittenzz
         WHERE KittenID='".$_POST['KittenID']."';";