calling MySQL stored function using mysql_

[Jivanmukta]

Hello,
I have little experience in PHP+MySQL programming. I need your help in such
problem: how to call stored MySQL function from PHP5 code using mysql_
interface? I failed to find solution in Internet.
Please help. Thank you!

[Jerry Stuckle]

Re: calling MySQL stored function using mysql_

Jivanmukta wrote:

Hello,
I have little experience in PHP+MySQL programming. I need your help in such
problem: how to call stored MySQL function from PHP5 code using mysql_
interface? I failed to find solution in Internet.
Please help. Thank you!
>
>

Just like any other MySQL query - with mysql_query().

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attgl obal.net
=============== ===

[Dikkie Dik]

Re: calling MySQL stored function using mysql_

Jivanmukta wrote:

Hello,
I have little experience in PHP+MySQL programming. I need your help in such
problem: how to call stored MySQL function from PHP5 code using mysql_
interface? I failed to find solution in Internet.
Please help. Thank you!
>

Just use the SQL syntax:
For a procedure, do
mysql_query('CA LL yourProcedure() ');
and for a function do
mysql_query('SE LECT yourFunction()' );