Originally Said By: Dani Chankhour
Do you get the same result if you removed DataAssist or do you always get that issue.
I have included the before and after code as well as a screenshot of the lines with errors.
Screenshot: codeerror.jpg
------------- Code before adding a record set: -----------
<?php
$Paramclient_id_WADAclients = "-1";
if (isset($_GET['client_id'])) {
$Paramclient_id_WADAclients = (get_magic_quotes_gpc()) ? $_GET['client_id'] : addslashes($_GET['client_id']);
}
$ParamSessionclient_id_WADAclients = "-1";
if (isset($_SESSION['WADA_Insert_clients'])) {
$ParamSessionclient_id_WADAclients = (get_magic_quotes_gpc()) ? $_SESSION['WADA_Insert_clients'] : addslashes($_SESSION['WADA_Insert_clients']);
}
$Paramclient_id2_WADAclients = "-1";
if (isset($_GET['client_id'])) {
$Paramclient_id2_WADAclients = (get_magic_quotes_gpc()) ? $_GET['client_id'] : addslashes($_GET['client_id']);
}
mysql_select_db($database_connKoparDashboard, $connKoparDashboard);
$query_WADAclients = sprintf("SELECT client_id, client_random, client_last, client_first, client_phone, client_message, client_cell, client_email, client_street, client_mailing, client_city, client_prov, client_postalcode, client_birth, client_gender, client_sin, client_maritial, client_visminor, client_aborig, client_disability, client_office, client_date, client_password, client_stafffirst, client_stafflast FROM clients WHERE client_id = %s OR ( -1= %s AND client_id= %s)", GetSQLValueString($Paramclient_id_WADAclients, "int"),GetSQLValueString($Paramclient_id2_WADAclients, "int"),GetSQLValueString($ParamSessionclient_id_WADAclients, "int"));
$WADAclients = mysql_query($query_WADAclients, $connKoparDashboard) or die(mysql_error());
$row_WADAclients = mysql_fetch_assoc($WADAclients);
$totalRows_WADAclients = mysql_num_rows($WADAclients);
if("" == ""){
$WA_mainMenu_1 = new WA_Include("../../_subs/mainMenu.php");
require($WA_mainMenu_1->BaseName);
$WA_mainMenu_1->Initialize(true);
}
if("" == ""){
$WA_footer_1 = new WA_Include("../../_subs/footer.php");
require($WA_footer_1->BaseName);
$WA_footer_1->Initialize(true);
}
?>
------------------ Code after adding a record set: -----------------
<?php
$Paramclient_WADAclients = "-1";
if (isset($_GET['client_id'])) {
$Paramclient_WADAclients = (get_magic_quotes_gpc()) ? $_GET['client_id'] : addslashes($_GET['client_id']);
}
$ParamSessionclient_WADAclients = "-1";
if (isset($_SESSION['WADA_Insert_clients'])) {
$ParamSessionclient_WADAclients = (get_magic_quotes_gpc()) ? $_SESSION['WADA_Insert_clients'] : addslashes($_SESSION['WADA_Insert_clients']);
}
$Paramclient_WADAclients = "-1";
if (isset($_GET['client_id'])) {
$Paramclient_WADAclients = (get_magic_quotes_gpc()) ? $_GET['client_id'] : addslashes($_GET['client_id']);
}
$Paramclient_id_WADAclients = "-1";
if (isset()) {
$Paramclient_id_WADAclients = (get_magic_quotes_gpc()) ? : addslashes();
}
$Paramclient_id2_WADAclients = "-1";
if (isset()) {
$Paramclient_id2_WADAclients = (get_magic_quotes_gpc()) ? : addslashes();
}
$ParamSessionclient_id_WADAclients = "-1";
if (isset()) {
$ParamSessionclient_id_WADAclients = (get_magic_quotes_gpc()) ? : addslashes();
}
mysql_select_db($database_connKoparDashboard, $connKoparDashboard);
$query_WADAclients = sprintf("SELECT client_id, client_random, client_last, client_first, client_phone, client_message, client_cell, client_email, client_street, client_mailing, client_city, client_prov, client_postalcode, client_birth, client_gender, client_sin, client_maritial, client_visminor, client_aborig, client_disability, client_office, client_date, client_password, client_stafffirst, client_stafflast FROM clients WHERE client_id = %s OR ( -1= %s AND client_id= %s)", GetSQLValueString($Paramclient_id_WADAclients, "int"),GetSQLValueString($Paramclient_id2_WADAclients, "int"),GetSQLValueString($ParamSessionclient_id_WADAclients, "int"));
$WADAclients = mysql_query($query_WADAclients, $connKoparDashboard) or die(mysql_error());
$row_WADAclients = mysql_fetch_assoc($WADAclients);
$totalRows_WADAclients = mysql_num_rows($WADAclients);
$colname_rsClientComments = "-1";
if (isset($_GET['client_id'])) {
$colname_rsClientComments = (get_magic_quotes_gpc()) ? $_GET['client_id'] : addslashes($_GET['client_id']);
}
mysql_select_db($database_connKoparDashboard, $connKoparDashboard);
$query_rsClientComments = sprintf("SELECT * FROM clientscomments WHERE clientcom_id = %s ORDER BY clientcom_date DESC", GetSQLValueString($colname_rsClientComments, "int"));
$rsClientComments = mysql_query($query_rsClientComments, $connKoparDashboard) or die(mysql_error());
$row_rsClientComments = mysql_fetch_assoc($rsClientComments);
$totalRows_rsClientComments = mysql_num_rows($rsClientComments);
if("" == ""){
$WA_mainMenu_1 = new WA_Include("../../_subs/mainMenu.php");
require($WA_mainMenu_1->BaseName);
$WA_mainMenu_1->Initialize(true);
}
if("" == ""){
$WA_footer_1 = new WA_Include("../../_subs/footer.php");
require($WA_footer_1->BaseName);
$WA_footer_1->Initialize(true);
}
?>