FoxPHP909 Posted February 9, 2008 Share Posted February 9, 2008 Hi this is my first post i would like some help with MySQL Stored Procedures and Functions i want to have a function for example which returns multiple rows for if i had a database which has two tables called cat and dog and i wanted a function called getAllCatsAndDogs(); which would perform a select on both tables how can i get a Stored Procedure / Function to return multi rows or values i know i need use a cursor but i have read its bad to do so an example of this would be nice Thank You, Your friendly newbie Quote Link to comment https://forums.phpfreaks.com/topic/90211-stored-procedures-and-functions/ Share on other sites More sharing options...
FoxPHP909 Posted February 11, 2008 Author Share Posted February 11, 2008 Just to update i was being an dumby hehe need to use mysqli for this :-) so it was not the procedure but the code Quote Link to comment https://forums.phpfreaks.com/topic/90211-stored-procedures-and-functions/#findComment-463985 Share on other sites More sharing options...
aschk Posted February 11, 2008 Share Posted February 11, 2008 Wasn't such a bad question really. I've only really worked with MySQL, but from what I can gather PostgreSQL requires some "dataset" defining or something crazy like that. I haven't played with it so can't confirm this, but this is what i remember from seeing it before. Quote Link to comment https://forums.phpfreaks.com/topic/90211-stored-procedures-and-functions/#findComment-463996 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.