0
<?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: Please use [code] tags to wrap your code.

2
Contributors
1
Reply
2
Views
7 Years
Discussion Span
Last Post by sam023
0
<?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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.