DELIMITER $$ CREATE DEFINER=`root`@`localhost` PROCEDURE `spr_StdUpdate`( IN STUDENT_ID INT ,IN STUDENT_NAME VARCHAR(40) ,IN STUDENT_ADDRESS VARCHAR(60) ,IN STUDENT_MOBILE VARCHAR(20) ,IN STUDENT_CLASS VARCHAR(20) ,IN STUDENT_EMAIL VARCHAR(60) ) BEGIN UPDATE students SET name=STUDENT_NAME, address=STUDENT_ADDRESS, mobile=STUDENT_MOBILE, class=STUDENT_CLASS, email=STUDENT_EMAIL WHERE ID=STUDENT_ID; END I Call it from php like this mysql_query("Call spr_StdUpdate('$name', '$address' ,'$mobile' ,'$class' ,'$email','$ID')") or die(mysql_error());
mysql_query("Call spr_StdUpdate('$ID','$name', '$address' ,'$mobile' ,'$class' ,'$email')") or die(mysql_error());
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)