Re: how to call a stored procedure in SQL Server 2000

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" <rasho@ving.co.yu> wrote in message news:20021227081907.33299.qmail@pb1.pair.com... > 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" <thien@joins.com> wrote in message > 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 > >