Thanks you Radovan and Frank very much I highly appreciate your answer.
It helps me to solve my problem quickly. thanks both of you agian "Radovan Radic" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I have sp like this in MSSQL > CREATE procedure dsp_ani_usage_period @from_date datetime, @to_date > datetime, @max_usage money > which does join select from some tables using these params for where > > And i execute it from PHP > > if(!isset($date_from)) > { > $date_from=date("m/d/Y",strtotime("-1 month")); > $date_to=date("m/d/Y"); > } > if (!isset($amount)) > $amount=20; > > $sql="exec dsp_ani_usage_period '$date_from','$date_to',$amount"; > $sql_result=mssql_query($sql); > > HTH, > Radovan > > "Ha Duy Thien" <[EMAIL PROTECTED]> wrote in message > 008d01c2ad60$d1caa6e0$311f483d@thien">news:008d01c2ad60$d1caa6e0$311f483d@thien... > Hi gurus, > > I am new user to PHP. > > Does anyone here work with SQL server with PHP, please show me some codes > about how to call a stored procedure in a SQL Server Database. > > how to add paramaters also > > Thanks a lot > > Thien > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
