Member Avatar for kbramprasath 
<?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

Edited by nav33n because: Please use [code] tags to wrap your code.
  • 2 Contributors
  • 1 Reply
  • 81 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by sam023
Member Avatar for sam023 
<?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.