No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
2 Posted Topics
[code=mysql] 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 [/code] it is my stored proceder how to call php code perfom delete operation
[code=php] <?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"); ?> [/code] it is my procedur [code=mysql] DROP PROCEDURE IF EXISTS `UsersR_DELETE_byPK` GO CREATE PROCEDURE UsersR_DELETE_byPK ( IN UsersID INT(11) ) BEGIN DELETE FROM UsersR …
The End.