The code below is supposed to add a new record to forum table.But when ever i executes it ,no error message and yet the new record is not insert into the table.please help.any help is appreciated.

PHP Code:

if ((isset($_POST["MM_category"])) && ($_POST["MM_category"] == "formadd")) {
  $insertSQL = sprintf("INSERT INTO forum ( forum_category) VALUES ( %s)",
                       GetSQLValueString($_POST['forumcat'], "text"));

  mysql_select_db($database_sql1, $sql1);
  $Result1 = mysql_query($insertSQL, $sql1) or die(mysql_error());
  $addGoTo = "editforumcat.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $addGoTo .= (strpos($addGoTo, '?')) ? "&" : "?";
    $addGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $addGoTo));
}
//the form to accept input from user
<form action="$_SERVER['PHP_SELF']" method="post" name="forumadd">
<table width="200" border="0" cellspacing="2" cellpadding="1">
  <tr>
    <td nowrap="nowrap">Category name</td><td><input name="forumcat" type="text" size="32" /></td>
   
  </tr>
</table>
<input type="hidden" name="MM_category" value="forumadd" />
<input name="" type="submit" value="Add to forum category" />
</form> 


Not 100% sure but this part does not look right to me. MySQL query should be formatted like the first section but I have never used sprintf try running raw commands trough phpmyadmin. Maybe turn this. INSERT INTO forum ( forum_category) VALUES ( %s) Into this. INSERT INTO `forum` ( `forum_category` ) VALUES ( '{%s}') Every professional I've seen uses the ` I never had any problems with or without it, but it might just work.

 $insertSQL = sprintf("INSERT INTO forum ( forum_category) VALUES ( %s)",                        GetSQLValueString($_POST['forumcat'], "text"));

why don't you change this confusing part

PHP Code:

$insertSQL = sprintf("INSERT INTO forum ( forum_category) VALUES ( %s)",
                       GetSQLValueString($_POST['forumcat'], "text")); 


to something easier?

PHP Code:

$f_cat = mysql_escape_string($_POST['forumcat']);
$insertSQL = "INSERT INTO forum SET forum_category = '".$f_cat."'"; 


I guess you are not getting any error because of blank value is getting inserted?