13 messages in com.mysql.lists.mysqlRe: Calling Stored Procedures from PHP
FromSent OnAttachments
Filipe Freitas27 Nov 2006 07:58 
Rolando Edwards27 Nov 2006 08:22 
Chris White27 Nov 2006 08:24 
Filipe Freitas27 Nov 2006 09:12 
Mike Kruckenberg27 Nov 2006 09:22 
Remo Tex28 Nov 2006 00:06 
Chris White28 Nov 2006 08:13 
Filipe Freitas28 Nov 2006 11:14 
dpgi...@mdanderson.org28 Nov 2006 11:26 
Kerry Frater28 Nov 2006 11:31 
ddev...@intellicare.com28 Nov 2006 12:55 
Kerry Frater28 Nov 2006 13:29 
Kerry Frater30 Nov 2006 05:25 
Subject:Re: Calling Stored Procedures from PHP
From:Mike Kruckenberg (mi@kruckenberg.com)
Date:11/27/2006 09:22:53 AM
List:com.mysql.lists.mysql

Filipe Freitas wrote:

Hi,

This is not a mysql thing but maybe you can help me. I want to call a stored procedure from PHP, so I tried it like normal querys: mysql_query("CALL mySP();"); with no success.

What is happening when you make the call? That might help get some more precise advice.

My understanding of using PHP with MySQL stored procedures is that you have to call them through the mysqli extension. It doesn't appear that you are using them. With them your would be using the mysqli_query() function.

I don't do a lot of PHP, but I stumbled into a similar problem and using the mysqli extensions solved the issue.