From a1a55b22184496e694fe4945f8479a4f940498f2 Mon Sep 17 00:00:00 2001
From: Jan Vales <jan@jvales.net>
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