Member Avatar for tlore22

Hello

I am a newbie with MS SQL and PHP. So if you could help it would be much appreciated.

I connected remoteley to a Microsoft SQL server 2005 database with PHP. I have to call a procedure (A) wich calls another procedure B within it. How do I get procedure A to call procedure B?
All I know are the input parameters. And when I execute the first procedure I get the result 1 ($result = mssql_execute($proc), $result is 1).
Both procedures do not have output parameters.

Thank you.

  • 2 Contributors
  • 1 Reply
  • 90 Views
  • 23 Hours Discussion Span
  • Latest Post Latest Post by lighthead
Member Avatar for lighthead

You can do it using stored procedure. In stored procedure A

exec ProcB param1 param2

where param1 and param2 are in parameters to Procedure B.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.