Re: how to call a stored procedure in SQL Server 2000
| From: | Radovan Radic | Date: | Fri, 27 Dec 2002 08:19:00 +0000 |
| Subject: | Re: how to call a stored procedure in SQL Server 2000 | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-24407@lists.php.net to get a copy of this message | ||
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