Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2002122

[PHP-DB] Re: how to call a stored procedure in SQL Server 2000 From: thien (thien <email protected>)
Date: 12/27/02

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 <email protected>> wrote in message
news:20021227081907.33299.qmail <email protected>
> I have sp like this in MSSQL
> CREATE procedure dsp_ani_usage_period  <email protected> datetime,  <email protected>
> datetime,  <email protected> 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 <email protected>> wrote in message
> news:008d01c2ad60$d1caa6e0$311f483d <email protected>
> 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