Re: Cant get Mysql stored procedure to work.

On Mon, Jul 13, 2009 at 11:52 AM, Patrick Moloney<webpat52@gmail.com> wrote: > I've had no success trying to execute any stored procedure from php. > I'm just trying to follow the example for multi-query in the php manual, and > have tried an example from Artfulsoftware.com. I have one input and one > output parameter. I've simplified the stored procedure to always output one > value from one record, regardless of the value passed in. > The SP works in Mysql. Just cant run it from php. It returns False. > I look at the query log in mysql and it calls the stored procedure, and > shows the input value and output variable. No further information. I'm not > familiar with that log so I don't know what it should look like. > The only thing I see looks like a brief reference to UTC8 - but I don't > think I am (intentionally) using that anywhere. I get no other error back or > logged. I'm using root as the user, which is the only defined user. Should > this work, or are stored procedures not working well? > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > Can you show the php code? -- Bastien Cat, the other other white meat