can't return a result set in the given context

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
RussellEngland
Forum Newbie
Posts: 8
Joined: Thu Nov 11, 2010 3:58 pm

can't return a result set in the given context

Post by RussellEngland »

I can create a stored procedure but getting an error when I try to call it, any ideas?

'can't return a result set in the given context'

I get the error in phpmyadmin and in php code.

mysql version 5.1.50

php version 5.2.14

Code: Select all

DELIMITER // 
CREATE PROCEDURE russtest 
(IN mylat FLOAT, IN mylong FLOAT) 
BEGIN 
SELECT * FROM jos_users; 
END // 

call russtest(0,0); 
RussellEngland
Forum Newbie
Posts: 8
Joined: Thu Nov 11, 2010 3:58 pm

Re: can't return a result set in the given context

Post by RussellEngland »

Tried it locally on LAMP and it works okay, so I'm guessing its an issue with the version of PHP?

Works with

mysql version 5.1.49-1ubuntu8

php version 5.3.3-1ubuntu9.1

Doesn't work with

mysql version 5.1.50

php version 5.2.14
Post Reply