stored procedures

[barnes]

can we call multiple select statements in one stored procedure.is it possible.plz explain any one..

[Roger_Ramjet]

You use BEGIN ... END

[MarkR]

You haven't said what database you're using. I'm assuming MySQL 5.

Yes you can. You can either return multiple result sets (in which case you need to use PDO or mysqli_ to be able to read them), or you can use the selects for intermediate work (e.g. selecting into temporary tables or variables) and return just one result set - or nothing.

Mark