<?php
include("config.php");

// $sql="delete from UsersR where  UsersID='$UsersID'";
$sql="CALL DeleteUsers('$_POST[UsersID]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "1 record deleted";


mysql_close($con);
header("location:delete.php");
?>

it is my procedur

DROP PROCEDURE IF EXISTS `UsersR_DELETE_byPK` 
GO

CREATE PROCEDURE UsersR_DELETE_byPK
   (
        IN  UsersID             INT(11) 
)	
BEGIN 

   DELETE FROM UsersR   
                     
           WHERE  UsersID=UsersID;
                             
        
  END

but i give delete means all row delete please responce immeditly

<?php
include("config.php");

// $sql="delete from UsersR where  UsersID='$UsersID'";
$sql="CALL DeleteUsers('$_POST[UsersID]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "1 record deleted";


mysql_close($con);
header("location:delete.php");
?>

it is my procedur

DROP PROCEDURE IF EXISTS `UsersR_DELETE_byPK` 
GO

CREATE PROCEDURE UsersR_DELETE_byPK
   (
        IN  UsersID             INT(11) 
)	
BEGIN 

   DELETE FROM UsersR   
                     
           WHERE  UsersID=UsersID;
                             
        
  END

but i give delete means all row delete please responce immeditly

if u trying to delete all records.. then remove where condition from query

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.