bontemuis
Member
Hi there,
I've visited already many corners of this forum, but I really can't figure this out. Please look at my php script in a form (onAfterProcess):
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$right_now = date();
$user_key_1 = (int) $formModel->formData['user_id_raw'];
$user_key_2 = (int) '{registration___id_raw}';
$query->insert('table2')->set('reg_id = ' . (int) ($user_key_2))->set('reg_user = ' . (int) ($user_key_1))->set('date = ' . ($right_now));
$db->setQuery($query);
$db->execute();
It doesn't accept date(), because I get this error message: 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 '' at line 4.
What goes wrong here?
I've visited already many corners of this forum, but I really can't figure this out. Please look at my php script in a form (onAfterProcess):
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$right_now = date();
$user_key_1 = (int) $formModel->formData['user_id_raw'];
$user_key_2 = (int) '{registration___id_raw}';
$query->insert('table2')->set('reg_id = ' . (int) ($user_key_2))->set('reg_user = ' . (int) ($user_key_1))->set('date = ' . ($right_now));
$db->setQuery($query);
$db->execute();
It doesn't accept date(), because I get this error message: 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 '' at line 4.
What goes wrong here?