View Single Post
  #2 (permalink)  
Old September 23rd, 2003, 08:53 AM
€urorunner €urorunner is offline
Registered User
 
Join Date: Sep 2003
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

forgot to post insert statement:

if ((isset($HTTP_POST_VARS["MM_insert"])) && ($HTTP_POST_VARS["MM_insert"] == "Brochure_requests")) {
$insertSQL = sprintf("INSERT INTO Brochure_Request (****_checkbox, *****_checkbox, First_name, Last_name, Address, Phone_no, Email) VALUES (%s, %s, %s, %s, %s, %s)",
GetSQLValueString(isset($HTTP_POST_VARS['****_checkbox']) ? "true" : "", "defined","'Y'","'N'"),
GetSQLValueString($HTTP_POST_VARS['*****_checkbox']) ? "true" : "", "defined","'Y'","'N'"),
GetSQLValueString($HTTP_POST_VARS['First_name'], "text"),
GetSQLValueString($HTTP_POST_VARS['Last_name'], "text"),
GetSQLValueString($HTTP_POST_VARS['Address'], "text"),
GetSQLValueString($HTTP_POST_VARS['Phone_no'], "int"),
GetSQLValueString($HTTP_POST_VARS['Email'], "text"));

mysql_select_db($database_DB_CONN, $DB_CONN);
$Result1 = mysql_query($insertSQL, $DB_CONN) or die(mysql_error());

mysql_select_db($database_DB_CONN, $DB_CONN);
$Result1 = mysql_query($insertSQL, $DB_CONN) or die(mysql_error());


My fudging around with the codes getting me into deeper bullcrap...now getting this error for the form page:

Parse error: parse error, unexpected ',' in /xxxx/xxxx/xxxx/xxxxxx/request_brochure.php on line 36

where line 36 =
GetSQLValueString($HTTP_POST_VARS['*****_checkbox']) ? "true" : "", "defined","'Y'","'N'"),

Its exactly the same as the line before it so wheres the problem?

Reply With Quote