diff -r aae5b0ecc47b -r a382de56a8e4 fhiiqm/raum_ins.php --- a/fhiiqm/raum_ins.php Thu Jan 12 11:41:22 2012 +0100 +++ b/fhiiqm/raum_ins.php Mon Feb 06 13:44:00 2012 +0100 @@ -97,6 +97,7 @@ $raum['rbez'] = substr($raum['rbez'],0,50); $raum['rnum'] = substr($raum['rnum'],0,10); if ($raum['rtyp']== -1) $rtyp = "NULL"; else $rtyp = "'" . $raum['rtyp'] . "'"; + if ($raum['reityp']== -1) $raum['reityp'] = null; // Filename Vertrag $raum['rfname'] = substr($raum['rfname'],0,50); if (isset($raum['rflae']) && $raum['rflae']>"0") @@ -124,11 +125,11 @@ if (is_object($stmt)) { if ($raum['rtyp']== -1) $raum['rtyp']=null; - $stmt -> prepare ("INSERT INTO Raum (raum_nr,raum_name,geb_ID,raumtyp_ID,raum_flaeche) VALUES (?,?,?,?,?)"); - $stmt -> bind_param('ssssd', $raum['rnum'], $raum['rbez'], $raum['geb'], $raum['rtyp'], $raum['rflae']); + $stmt -> prepare ("INSERT INTO Raum (raum_nr,raum_name,geb_ID,raumtyp_ID,reinigung_typ_ID,raum_flaeche) VALUES (?,?,?,?,?,?)"); + $stmt -> bind_param('sssssd', $raum['rnum'], $raum['rbez'], $raum['geb'], $raum['rtyp'], $raum["reityp"], $raum['rflae']); $result = $stmt -> execute(); } - if ($dbc->error) echo "error: " . $dbc->error . "

\n"; + if ($stmt->error) echo "error: " . $stmt->error . "

\n"; if ($result) { // INSERT o.k. // raum_ID ermitteln