Trying to insert into 2 tables at same time?
Posted: Thu Oct 04, 2007 3:48 am
I cant figure out where I'm going wrong... I'm trying to insert data into 2 different tables at the same time?
My code looks like this:
Can somebody please help?
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);
}