agupta2683

Hi All, I have  a form which asks a user to add and delete the fields. These fields r defined in the backend database. I'm using POST method on the submission and once the user presses submit, the control goes to the form_submit page. This page uses isset($_get[' ']) method to retrive the values entered by the user and perform insertion or deletion operations in the database. The code is not throwing any error . when a user tried to enter the values for the fields on the form, the insertion or deletion operations are not performed in the database. I have checked that I have made connection to the database. I tried different if else combinations but it doesnt seem to work. I have also attached the code if anyone can be kind enough to have a look at it. I would highly appreciate any sort of help in this. CODE <?php           if( isset( $_GET[ 'region' ], $_GET ['addstate'],$_GET ['deletestate']) )       {         $addstate = $_GET[ 'addstate' ];         $deletestate = $_GET[ 'deletestate' ];            $region = $_GET[ 'region' ];         $query  = "INSERT INTO dbo.off_campus_ashish VALUES ('$region', '$addstate') AND DELETE * FROM dbo.ashishdate WHERE region = '$region' AND state = '$deletestate'" ;         mssql_query($query);         //$result = db_query( "INSERT INTO dbo.ashishdate VALUES ($category, $addate) AND DELETE * FROM dbo.ashishdate WHERE category = $category AND date = $deletedate");         }       else       {       if( isset( $_GET[ 'region' ],$_GET ['addstate']) )         {         $addstate = $_GET[ 'addstate' ];         $region = $_GET[ 'region' ];         $query  = "INSERT INTO dbo.off_campus_ashish VALUES ('$region', '$addstate')";         mssql_query($query);         //$result = db_query( "INSERT INTO dbo.ashishdate VALUES ($category, $addate)");         }               else       {         if (isset( $_GET[ 'region' ], $_GET ['deletestate']) )         {         $deletestate = $_GET[ 'deletestate' ];            $region = $_GET[ 'region' ];         $query  = "DELETE * FROM dbo.off_campus_ashish WHERE region = '$region' AND state = '$deletestate'" ;         mssql_query($query);         //$result = db_query("DELETE * FROM dbo.ashishdate WHERE category = $category AND date = $deletedate");         }         else         {         echo "You did not submit all the required information.  Please go back and try again.";         }         }         }     ?>