<?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