MySQL Forums
Forum List  »  PHP

Stored procedure
Posted by: praba karan
Date: January 08, 2008 06:15AM

CREATE PROCEDURE `check`(tableName char(100), fieldName char(100), fieldValue int(10), out flag char(100))
BEGIN

SET @s= CONCAT('select count(*) from ',tableName,' where ',fieldName,' = ',fieldValue);
prepare stmt from @s;
execute stmt;


END

How to execute the above stored procedure in PHP?
thanks Advance

Options: ReplyQuote


Subject
Written By
Posted
Stored procedure
January 08, 2008 06:15AM
January 08, 2008 10:10AM
January 08, 2008 11:21PM
January 09, 2008 03:04PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.