Earler, we posted an article from DevArticles about executing stored procedures in Microsoft SQL server through PHP - well, now it's SitePoint's turn to show their stuff.

In Stored Procedures on PHP and Microsoft SQL Server, the author notes: Though it's not as common a combination as PHP and MySQL, PHP and Microsoft SQL Server can be a powerful team. You can query SQL Server databases easily and effectively using the PEAR database abstraction layer, just as you would a MySQL database. But once you start trying to use one of the primary benefits of SQL Server over MySQL -- namely, stored procedures -- a few problems quickly become apparent...

He goes on to talk about a new class he has worked up to help with this link between SQL Server and PHP - the SqlCommand class. Containing only 6 methods, it allows you to quickly and easily handle the stored procedures and their results in your script. The examples he gives make it look as simple as any MySQL connection ever was, and drop the output to a variable for use and abuse later...