Evo, tačno iznad moje kode imam:
// save to db
$sSql = "INSERT INTO #__sv_apptpro2_requests(".
"name, ".
"user_id, ".
"phone, ".
"email, ".
"sms_reminders, ".
"sms_phone, ".
"sms_dial_code, ".
"resource, ".
"category, ".
"service, ".
"startdate, ".
"starttime, ".
"enddate, ".
"endtime, ".
"request_status, ".
"payment_status, ".
"cancellation_id, ".
"booking_total, ".
"booking_due, ".
"credit_used, ".
"coupon_code, ".
"booked_seats, ".
"admin_comment, ".
"booking_language, ".
"manual_payment_collected, ".
"operator, ".
"comment ";
$sSql = $sSql.") VALUES(".
"'".$database->getEscaped($name)."',".
"'".$user_id."',".
"'".$database->getEscaped($phone)."',".
"'".$database->getEscaped($email)."',".
"'".$sms_reminders."',".
"'".$database->getEscaped($sms_phone)."',".
"'".$sms_dial_code."',".
"'".$resource."',".
"'".$category."',".
"'".$database->getEscaped($service_name)."',".
"'".$startdate."',".
"'".$starttime."',".
"'".$enddate."',".
"'".$endtime."',".
"'".$request_status."',".
"'".$payment_status."',".
"'".$cancel_code."',".
$grand_total.",".
$amount_due.",".
$applied_credit.",".
"'".$coupon_code."',".
"'".$booked_seats."',".
"'".$database->getEscaped($admin_comment)."',".
"'".$lang->getTag()."',".
"'".$database->getEscaped($manual_payment_collected)."',".
"'".$database->getEscaped($operator)."',".
"'".$database->getEscaped($comment)."'";
$sSql = $sSql.")";
//echo $sSql;
//exit;
$database->setQuery($sSql);
if (!$database->query()) {
$err = $database->getErrorMsg();
echo $err;
$database->setQuery("UNLOCK TABLES;");
$database->query();
exit;
}
I u ovu tablicu ide bez problema
Ako stavim i kod ove tablice:
Code: Select all
if (!$database->query()) {
$err = $database->getErrorMsg();
echo $err;
$database->setQuery("UNLOCK TABLES;");
$database->query();
exit;
}
onda dobijem:
Code: Select all
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 ''operator', 'request_id', 'user_id', 'date', 'time', 'status' ) VALUES('238','1'' at line 1 SQL=INSERT INTO aml8c_card_status_history('operator', 'request_id', 'user_id', 'date', 'time', 'status' ) VALUES('238','1','323','2012-10-16','09:34:09','accepted')