Posted by eholz1 on 04/02/07 15:33

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

• Next in forum: Re: Problem echoing \r\n
• Prev in forum: php scripts no longer working after upgrade
• Thread view: Stored procedures, MySQL, and PHP

[Reply to this message]