Execute procedure

[vanlohan]

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

[rincewind456]

Well as that's a Mysql query you may want to look at [man]mysql_query()[/man] or [man]mysqli_query()[/man]