From a1a55b22184496e694fe4945f8479a4f940498f2 Mon Sep 17 00:00:00 2001 From: Jan Vales Date: Fri, 31 Jul 2015 13:52:51 +0200 Subject: [PATCH] fix insert. Forgot to add a ", ?" when adding gruppenfotoerlaubnis. --- db_funcs.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/db_funcs.php b/db_funcs.php index 8c23304..b7e56fe 100644 --- a/db_funcs.php +++ b/db_funcs.php @@ -76,7 +76,7 @@ function db_store_person($id, $pdata){ if($pdata['vorwissen'] == '')$pdata['vorwissen'] = 0; if($pdata['gebdatum'] == '')$pdata['gebdatum'] = '1900-01-01'; $prep = $GLOBALS['dbc']->prepare('INSERT INTO anmeldungen(uname, nname, vname, gebdatum, nationaliaet, sprachen, analphabet, bemerkungen, - vorwissen, fotoerlaubnis, gruppenfotoerlaubnis, videoerlaubnis, status, termin) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) returning id;'); + vorwissen, fotoerlaubnis, gruppenfotoerlaubnis, videoerlaubnis, status, termin) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) returning id;'); $prep->execute(array($GLOBALS['uname'], $pdata['nname'], $pdata['vname'], $pdata['gebdatum'], $pdata['nationaliaet'], $pdata['sprachen'], $pdata['analphabet'], $pdata['bemerkungen'], $pdata['vorwissen'], $pdata['fotoerlaubnis'], $pdata['gruppenfotoerlaubnis'], $pdata['videoerlaubnis'], $pdata['status'], $pdata['termin'])); -- 2.43.0