Calling stored procedure from PHP

[Preston McMurry]

Grepped this site and Google as well, and only found one (sorta) example. I'm familiar with PHP, SQL and stored procedures in general, but am unsure as to the proper syntax for combining them in MySQL. Here is a conversation with someone else where I work:

-----

Them: So, If we were using some sort or query execute method, it would be similar to

$db->query(“call StoredProcedure(param, param);”);

I’m asking cause I don’t know.

-----

Me: That looks like the syntax to me ... well, except in PHp it would probably be more like:

$db->query('call StoredProcedure($paramX, $paramY)');

-----

We are currently using 4.1.9-nt, and are thinking about changing to 5.0.x, thus the question (and lack of experience ...)

http://prestonm.com ... http://www.mcmurry.com