Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #72.7K
Re:
Any could give me a PHP script on how to call or execute mysql stored procedure. Thank you. Roland |
|
[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 … |