Executing a stored procedure on mssql and passing a datetime

[ideasworking]

Hello,

 

I've exhausted everything I can think of and I still can't execute an mssql stored procedure with a datetime variable from PHP. Would someone look at my code and suggest a solution? I know the sp works and if I enter EXEC Reporting.dbo.CalculateDaily Totals '2007-10-31' the daily totals for for today are calculated. So I really don't see why my php code doesn't work. Any suggestions are welcome.

 

Thanks,

Lou

 

$RecDate = date("Y-m-d",strtotime($_POST['RecalcDate'])); 

$db = mssql_connect("server","user","password") or die("Unable to connect to server");
$query = "EXEC Reporting.dbo.CalculateDailyTotals '$RecDate'";
$Result= mssql_query($query, $db);

if ($Result == 1){
echo "Success";
} ELSE {
echo "Failure";
}