Hi Ray,
I don't get an error, the page seems to do it's thing but the db is not updated and when the page reloads the change is not there.
There was one thing I changed, which I assumed would be ok.
In my orignal code, 2 of the blocks of code you had me move were surrounded by the same php tags <?php ?> Since you indicated they needed to be split, I added the ending tag to the first block and an opening tag to the second block, creating 2 seperate blocks. ie.
<?php
if (!isset($_SESSION)) {
session_start();
}
?>
<?php require_once('Connections/members.php'); ?>
<?php require_once( "WA_SecurityAssist/Helper_PHP.php" );
?>
<?php require_once("WA_DataAssist/WA_AppBuilder_PHP.php"); ?>
<?php require_once("WA_DigitalFilePro/HelperPHP.php"); ?>
<?php
if (!WA_Auth_RulePasses("Logged in to members")){
WA_Auth_RestrictAccess("members_LogIn.php?notLogged=true");
}
**********
you had me split the code here and insert the WA_DFP_SetupUploadStatusStruct and WA Application Builder Update code. essentially moving the next chunk of code down, so I ended the code block above with ?> and added a <?php tag to the next chunk.
**************
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
?>