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: Radovan Radic (rasho <email protected>)
Date: 12/27/02

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