[PHP-DB] Re: how to call a stored procedure in SQL Server 2000

[Radovan Radic]

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