I am trying to submit data entered in a form to a database table. I have followed the online example however, the data just sits in the "submitted data" section and does not get copied into my desired table.

The table is in the same database as my joomla site and the rsform tables.

I am using rsform! not rsform!pro, I have read that a mapping plugin can be used on the pro version however I want to stick with the free version if possible.

Is there a solution to this or do I have to buy the full version?

Regards,

Tim

Hi this works for me: (using Joomla 1.5.22 + RSForm 1.0.6):

if(isset($_POST)){

$fechaSolicitud=$_POST; // textbox
$nombreSolicitante=$_POST; // textbox
$nacionalidad=$_POST; // input type select

$nac='';
for($i=0; $i<count($nacionalidad); $i++ ) {
$nac=$nacionalidad[$i];
}

$correo=$_POST ; // textbox


$database->setQuery("
INSERT INTO intra_form_tablename
(fecha_sol, nombre, nacionalidad, correo_sol)
VALUES (
STR_TO_DATE('".$fechaSolicitud."','%Y/%m/%d' ) ,
'".$nombreSolicitante."',
'".$nac."',
'".$correo."' )
" ) ;

$database->query() ;
}

good luck!