Posted 25 January 2014 - 04:06 PM
i wanna make a stored procedure of my queries below and use it on my php program.
can anyone help me? Please
INSERT INTO afnup_worksheet (faic,fnl_name,ftotal)
,(SELECT SUM(inttotal) FROM app_interview t2 WHERE t2.atic = t.atic)/7
FROM app_interview t
GROUP BY atname HAVING COUNT(DISTINCT atic)
SELECT count(t.atic) as total,t2.name
FROM app_interview as t, tb_applicants as t2
WHERE t.atic = t2.aic
GROUP BY t.atic;
Posted 25 January 2014 - 04:48 PM
Stored procedures are "stored" on the database server, therefore you cannot use them in the PHP server. However, you can store a procedure, and call it from a different program such as PHP. In standard SQL you would use the MySQL CALL or the SysBase CALL or the Oracle CALL syntax. Of course, that list goes on and on.
1 user(s) are reading this topic
0 members, 1 guests, 0 anonymous users