Posted by Schraalhans Keukenmeester on 04/03/07 10:53

eholz1 wrote:
> Hello PHP group,
>
> Could someone help me out? I have PHP 5.2, Apache 2.0, and MySQL 5.0
> running on Linux (Redhat Fedora Core 6).
>
> All that works fine. I would like to be able to "call" a stored
> procedure from a PHP program, and
> run a stored procedure. I have yet to figure out the proper way to do
> this. My stored procedures work fine from the mysql command line
> using syntax: "call sp_min_record (101);"
>
> But when I try to do the same thing within my PHP page - no luck I get
> an error.
>
> Here is my stored procedure code:
>
> DELIMITER $$
>
> DROP PROCEDURE IF EXISTS `portfolios`.`sp_min_record` $$
>
> CREATE DEFINER=`ewh`@`localhost` PROCEDURE
> `portfolios`.`sp_min_record`
> (IN folio INT)
> BEGIN
> SELECT MIN(id) INTO minr FROM images3 WHERE p = folio;
> END$$
>
> DELIMITER ;
>
> and here is how I am trying to call it from php:
>
> $dbconnect = db_connect('portfolios') or trigger_error("Error
> Connecting to Database: "
> . mysql_error(), E_USER_ERROR);
>
> $help = @mysql_query("call sp_min_record ($folio)");
> $rowx = @mysql_fetch_assoc($help);
>
> $minrec = $rowx[0];
>
> but I get no value returned. How am I supposed to do this
> (correctly :))?
> Thanks,
> eholz1
>
You fetch an associative array and then access $rowx[0].
I'd expect a field name instead.

HTH

Sh.

[Back to original message]