Call stored procedure and Report the results

[mrviber]

hey,
am coding in php and i would like assistance into how i can call a stored procedure and also how i can report data processed from the stored procedure.
am doing a billing system and i need to produce invoices.
Thanks

[tomhath]

Lots of articles on the subject. Try a Google search.

[MarkR]

Calling a stored procedure is no different than a conventional (SELECT) query in most databases.

Some allow things like output parameters however, if you choose to use these you must bind them especially.

If the procedure returns multiple result sets, you must use special code to cater for this (in MySQL this means using mysqli or PDO, not the plain mysql_ functions which don't support it).

Read the docs for your database and PHP for more info.

Mark