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 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 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. Link to comment https://forums.phpfreaks.com/topic/90211-stored-procedures-and-functions/#findComment-463996 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.