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

Reply via email to