MySQL - Execute procedure

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!!

Look into the mysqli extension. See http://us.php.net/mysqli