call MySQL stored procedure from php

Hi All,
>
Has anyone tried calling MySQL stored procedure from php scripts?
I use PEAR DB module to access MySQL database.
Not sure if php 4.4.0 (that we use) support calling stored procedures.
>
Regards,
Urmi
>
>

Urmi Biswas wrote:>
I know of no reason why php 4.x (it's now backlevel and no longer
supported - you should update ASAP) shouldn't support it, but php 5.x
supports it fine.
>
Did you try it?
>
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

"Jerry Stuckle" <jstucklex@attglobal.netwrote in message
news:gg1th3$5dc$2@news.motzarella.org...Thanks Jerry for replying.
>
I tried the following:
>
$sth=$db->prepare("call validateFBT(?,?)");
$bindvars=array("1" =$SelectedFBT,"2" =$frequency);
$res=$db->execute($sth,$bindvars);
>
if (DB::iserror($res)) {
die($res ->getMessage( ));
}
>
I get 'DB Error: unknown error'.
>
Regards,
Urmi
>

Urmi Biswas escribió:>
According to the example in docs execute() seems to expect a numeric
zero-based array:
>
http://pear.php.net/manual/en/packag...on.execute.php
>
Check whether you get the same error if you don't specify array indexes
(which are not needed anyway).
>

Álvaro G. Vicario wrote:>
Good catch, Álvaro. That one went right by me.
>
>
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================