mssql stored procedure execution failed (???)

[TheCraftyBeaver]

Hi, I'm a complete novice at PHP and SQL. I'm trying to get data put into a form to be entered into a mssql database table. I didn't write this code from scratch (someone sent it to me and I've changed the fields/variables, etc.), and I really can't troubleshoot beyond the absolute, bare basics. Anyway, when I submit the form, I get this error:

Warning: mssql_execute(): stored procedure execution failed in C:\Inetpub\cityoffrederick.com\NewWebsite\TestForms\nacregistry\register.php on line 133

So, apparently my stored procedure isn't working at all. A syntax check says it's correct, and syncs up with my table. Here's the PHP code I'm using:

<?php

$myServer = "***";
$myUser = "";
$myPass = "*";
$myDB = "****";

$s = @mssql_connect($myServer, $myUser, $myPass)

or die("Couldn't connect to SQL Server on $myServer");

$d = @mssql_select_db($myDB, $s)
or die("Couldn't open database $myDB");

$query = mssql_init("sp_NACRegister", $s);

$nac = $POST["nac"];
$citizen = $POST["citizen"];
$whoregister = $POST["whoregister"];
$address = $POST["address"];
$neighborhood = $POST["neighborhood"];
$cellpager = $POST["cellpager"];
$phone = $POST["phone"];
$emergency = $POST["emergency"];
$walk = $POST["walk"];
$walkaid = $POST["walkaid"];
$wheelchair = $POST["wheelchair"];
$oxygentank = $POST["oxygentank"];
$electricity = $POST["electricity"];
$dialysis = $POST["dialysis"];
$hearingimp = $POST["hearingimp"];
$otherassist = $POST["otherassist"];
$precautions = $POST["precautions"];
$seminar = $POST["seminar"];
$email = $POST["email"];
$hear = $POST["hear"];
$moving = $_POST["moving"];

mssql_bind($query, "@nac1", $nac, SQLTEXT);
mssql_bind($query, "@citizen1", $citizen , SQLTEXT);
mssql_bind($query, "@whoregister", $whoregister , SQLTEXT);
mssql_bind($query, "@address1", $address, SQLTEXT);
mssql_bind($query, "@neighborhood1", $neighborhood , SQLTEXT);
mssql_bind($query, "@cellpager1", $cellpager , SQLTEXT);
mssql_bind($query, "@phone1", $phone, SQLTEXT);
mssql_bind($query, "@emergency1", $emergency, SQLTEXT);
mssql_bind($query, "@walk1", $walk , SQLTEXT);
mssql_bind($query, "@walkaid1", $walkaid , SQLTEXT);
mssql_bind($query, "@wheelchair1", $wheelchair , SQLTEXT);
mssql_bind($query, "@oxygentank1", $oxygentank , SQLTEXT);
mssql_bind($query, "@electricity1", $electricity , SQLTEXT);
mssql_bind($query, "@dialysis1", $dialysis , SQLTEXT);
mssql_bind($query, "@hearingimp1", $hearingimp , SQLTEXT);
mssql_bind($query, "@otherassist1", $otherassist1 , SQLTEXT);

mssql_bind($query, "@precautions1", $precautions, SQLTEXT);
mssql_bind($query, "@seminar1", $seminar, SQLTEXT);
mssql_bind($query, "@hear1", $hear, SQLTEXT);
mssql_bind($query, "@email1", $email, SQLTEXT);
mssql_bind($query, "@move1", $move , SQLTEXT);

$result = mssql_execute($query);

?>

The line that I'm getting the error on is "$result = mssql_execute($query);."

Does anyone have any idea what might be wrong (with either my coding or the database)--or does anyone know of an easier way to have form info entered into a table?

Thanks!

-Katie