Loop a Stored Procedure

[jrahma]

Hi,

I have a sample stored procedure sp_get_employee_leave with:

SELECT employee_leave_day FROM employees WHERE employee_id = param_employee_id;

I want to know how can I call sp_get_employee_leave to get the data for all employees using a loop.. something like:

For (i=0; i<=rows_number_in_employees_table; i++)
{
   print sp_get_employee_leave(i);
}

what's the best way to do it?

Thanks,
Jassim

[NogDog]

It should be callable via whatever database extension you're using as a DB query, something like:

$result = mysqli_query("sp_get_employee_leave($i)");

However, putting that into a loop would seem rather inefficient, as opposed to coming up with one query (stored procedure?) that queries all rows in that table at once, returning a multi-row result set you could then iterate through.

[jrahma]

sorry I wanted this in SQL.

Appreciate if you move this to MySQL forum..