Problem with Submitting

bennie

When I click "Submit", I want the page to go to another page that tells me "Form successfully submitted." I have the following code but i get an error around the IF(@($sql)) part. Doe anyone know whats wrong?

if ($Submitform == "Submit") {
$ID_result = mysql_query("SELECT MAX(SM_ID*1) + 1 FROM tbl_sm");
$max_id = mysql_result($ID_result, 0, 0);

 $sql = ("INSERT INTO tbl_sm SET 
        	SM_ID='$max_id', 
	SM_CLLI='$RedbackCLLI',
	SM_ANS_NAME=' $RedbackName',
	SM_SERIAL='$RedbackChasisSerial',
	SM_MODEL='$RedbackModel',
	SM_CODE_REVISION='$RedbackAOSVersion',
	SM_RELAY_RACK='$RedbackRelayRackPosition',
	SM_MGMT_IP1='$RedbackMgmt1Address1',
	SM_MGMT_IP2='$RedbackMgmt1Address2',
	CO_ID='$CentralOfficeLocationID',
	CONSOLE_ID='$RedbackConsoleNumber',
	SM_MGMT_SM_ID='$RedbackMarketAreaforRWPS'"); 

  if (@mysql_query($sql)) { 

   echo("<FORM METHOD="post" ACTION="Submitted.php">");
 } else { 
   echo("<p>Error adding submitted form: " . 
     	mysql_error() . "</p>");
  }

}

<form action="<?=$PHP_SELF?>" method="post">
blah
</form>

kevinsequeira

$result = mysql_query($sql);
if (!mysql_error()) {

echo("form submitted");
} else {
echo("<p>Error adding submitted form: " .
mysql_error() . "</p>");
}

reg
kevin

bennie

Thanks, but yea, this is what I had or used before to test my code. But I want the page to link to another SEPARATE page when I click SUBMIT...not stay on the current page with the "form submitted" statement printed out on top. Got any ideas?