[SOLVED] where am i going wrong

[jkkenzie]

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}

$insertSQL = sprintf("INSERT INTO content (id, title, shortdesc, longdesc, pic, group, date, author, active) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s)",GetSQLValueString($_POST['id'], "int"),GetSQLValueString($_POST['Teasertitle'], "text"),GetSQLValueString($_POST['Teasertxt'], "text"),GetSQLValueString($_POST['Brief'], "text"),GetSQLValueString($_POST['Highres'],"text"),GetSQLValueString($_POST['Keywords'], "text"),GetSQLValueString($_POST['Startdate'], "date"),GetSQLValueString($_POST['Author'], "text"),GetSQLValueString(isset($_POST['Active']) ? "true" : "", "defined","1","0"));
  
echo $insertSQL;
  mysql_select_db($database_app_conn, $app_conn);

  $Result1 = mysql_query($insertSQL, $app_conn) or die(mysql_error());

 

the code above give me the below error:

INSERT INTO content (id, title, shortdesc, longdesc, pic, group, date, author, active) VALUES (NULL, 'gfhgfhgf', '
gfhgfhgfhgfhgfh

', '
fghfghjhhfghgf

', 'default.jpg', 'dfhggfh', '2008-12-31', 'fghgfhfg', 1)You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group, date, author, active) VALUES (NULL, 'gfhgfhgf', '
gfhgfhgfhgfhgfh

',' at line 1

where am going wrong?

SURPRISINGLY THE ONE BELOW WORK ON ANOTHER PAGE:

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}

$insertSQL = sprintf("INSERT INTO events (id, Teasertitle, Teasertxt, Brief, Speaker, Information, Caption, Highres,Venue, Keywords, Enddate, Startdate, Author, Active, Category) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['id'], "int"),
                       GetSQLValueString($_POST['Teasertitle'], "text"),
                       GetSQLValueString($_POST['Teasertxt'], "text"),
                       GetSQLValueString($_POST['Brief'], "text"),
                       GetSQLValueString($_POST['Speaker'], "text"),
                       GetSQLValueString($_POST['Information'], "text"),
                       GetSQLValueString($_POST['Caption'], "text"),
                       GetSQLValueString($_POST['Highres'],"text"),
				   GetSQLValueString($_POST['Venue'], "text"),
                       GetSQLValueString($_POST['Keywords'], "text"),
                       GetSQLValueString($_POST['Enddate'], "date"),
                       GetSQLValueString($_POST['Startdate'], "date"),
				   GetSQLValueString($_POST['Author'], "text"),
                       GetSQLValueString(isset($_POST['Active']) ? "true" : "", "defined","1","0"),
                       GetSQLValueString($_POST['Category'], "text"));
  mysql_select_db($database_app_conn, $app_conn);

  $Result1 = mysql_query($insertSQL, $app_conn) or die(mysql_error());

[xtopolis]

group is a MYSQL reserved word.

[jkkenzie]

Oh God, its amazing how such small tiny little bugs can hitch So much.

 

thanks and God bless a million