Forums

Hello,

I suppose my question is simple, but I can't solve it:
I need to insert a new record in a table different from the one the Form is connectet to.
The value will be a field in the form.
But I cannot just INSERT anything in the second table (my_table).

I have done this simple test, put in the Submit section:
<? $db = &JFactory::getDBO(); $query = "INSERT INTO my_table (tema) VALUES ('Ciao')"; $db->setQuery($query); ?>

Any idea?

Thanks in advance,
Gonzalo Miranda

Hi GMiranda,

You also need to include the line of code to execute the query, setQuery() only sets it :<? $db = &JFactory::getDBO(); $query = "INSERT INTO `my_table` (`tema`) VALUES ('Ciao')"; $db->setQuery($query); $db->query(); // <-- add this line ?>
Bob