Skip navigation links

MySQL Forums :: PHP :: Execute procedure


Advanced Search

Execute procedure
Posted by: Vanessa Tan ()
Date: November 04, 2009 02:57AM

Hi, I am a student and was given a task to provide the lines of PHP code used to execute a procedure in a MySQL database.

I am very very weak in PHP, to be honest, I don't know what does the codes mean. Need help from anyone here, please!!

The codes given are as below:

DROP PROCEDURE IF EXISTS `a1`.`sp_archive`$$

CREATE PROCEDURE `a1`.`sp_archive` ()
BEGIN
DELETE FROM users WHERE last_login < DATE_ADD(sysdate(), INTERVAL -1 YEAR);
END$$


Thanks!!

Options: ReplyQuote


Subject Written By Posted
Execute procedure Vanessa Tan 11/04/2009 02:57AM
Re: Execute procedure Peter Brawley 11/04/2009 07:07AM


Sorry, only registered users may post in this forum.