Page 1 of 1

return dataset from stored procedure

Posted: Sat Jun 27, 2009 8:56 am
by ercie34
hello everybody,

i have a stored procedure in mysql which has sql statement like

"select * from table"

in my table i have 14,000 records,

how can i use this stored procedure in php and how can i make the store return all the records in recordset in php?

thanks in advange

Re: return dataset from stored procedure

Posted: Sat Jun 27, 2009 9:45 am
by McInfo
MySQL Manual: CALL

PHP Manual: Prepared statements and stored procedures

Edit: This post was recovered from search engine cache.