0){ //already exists $message['type'] = "error"; $message['text'] = " Form ".$formText." already exists"; }else{ $sql=" INSERT INTO dw_form ( formText, formOrder, formModUser , formSite , formModDate, formActive) VALUES ( ? , ? , ? , ? , now() , 1 ) "; if(!savesql($link, $sql, "siii", array($formText, $formOrder, $_SESSION['userID'], $_SESSION['userSite'] ), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__); } }else{ if(isset($_POST['edit_id']) && $_POST['edit_id']!='' && $_POST['edit_id']!=null){ $edit_form = clean($_POST['edit_form']); $edit_order = clean($_POST['edit_order']); $edit_order_old = clean($_POST['edit_order_old']); if(isset($_POST['edit_active'])) $edit_active = clean($_POST['edit_active']); else $edit_active = 0; $edit_reason = clean($_POST['edit_reason']); if($edit_order_old!= $edit_order){ $sql=" # update all the form orders +1 Select dw_form.formID, dw_form.formOrder From dw_form Where dw_form.formOrder > ? And dw_form.formOrder <= ? And dw_form.formSite = ? "; if(!$qryforms = mysqli_prepared_query($link, $sql, "iii", array($edit_order_old, $edit_order, $_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__); foreach($qryforms as $form_row){ $sql=" UPDATE dw_form SET formOrder = ? WHERE formID = ? "; if(!savesql($link, $sql, "ii", array(($form_row['formOrder']+1), $form_row['formID']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__); } } //update this form $sql=" UPDATE dw_form SET formText = ?, formOrder = ?, formActive = ?, formChangeCode = ?, formModDate = now(), formModUser = ? WHERE formID = ? "; if(!savesql($link, $sql, "siisii", array($edit_form, $edit_order, $edit_active, $edit_reason, $_SESSION['userID'], $_POST['edit_id']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__); } } $title = "Submission forms"; require "inc/head.php"; $menu="form"; require "inc/menu.php"; if($debug) showdebug(); ?>

99 Order By dw_form.formOrder DESC, dw_form.formText DESC Limit 1 "; if(!$order_query = mysqli_prepared_query($link, $sql, "i", array($_SESSION['userSite']), FILE, LINE)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], FILE, LINE); if(mysqli_prepared_num_rows($order_query)>0){ $order_row = $order_query[0]; }else $order_row=array('formID'=>1); ?>

Please wait while loading...