My code looks like this:
Code: Select all
$cluid = $db->GenID (cms_db_prefix ()."module_clubmanager_clubs_seq");
$query = "INSERT INTO ".cms_db_prefix ()."module_clubmanager_clubs VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
$dbresult = $db->Execute ($query, array ($cluid,
$params["input_clubid"],
$params["input_nation"],
$params["input_letter"],
$params["input_clubname"],
$params["input_clubalias"],
$params["input_password"],
$params["input_18"],
$params["input_18_9"],
$params["input_27"],
$params["input_36"],
$params["input_9"],
$params["input_adress1"],
$params["input_adress2"],
$params["input_adress3"],
$params["input_zipcity"],
$params["input_phone"],
$params["input_fax"],
$params["input_email"],
$params["input_homepage"]));
$infoid = $db->GenID (cms_db_prefix ()."module_clubmanager_clubinfo_seq");
$query = "INSERT INTO ".cms_db_prefix ()."module_clubmanager_clubinfo VALUES (?,?,?,?,?)";
$dbresult = $db->Execute ($query, array ($infoid,
$params["input_clubid"],
$params["input_nation"],
$params["input_clubname"],
$params["input_clubalias"],
$params["input_password"]));
if (!$dbresult) {
echo $db->ErrorMsg();
return;
}
if ($error) {
echo $this->ProcessTemplate ('addclub.tpl');
}
else {
$this->Redirect ($id, 'defaultadmin', $returnid);
}