Originally Said By: Jason Byrnes
do you mean in the body? The bindings to show the recordset columns? that code will not be removed when editing the recordset. editing the recordset only changes the recordset, it does not change anything else on the page.
the code to show those columns will need to be removed manually.
Hi Jason, no not the body the code in the head section. Example below is from a details page, I removed the tblcases.CaseOfferedDate, tblcases.CaseCompletedDate, tblcases.CaseNPWDate columns for the recordset but they still appear above head section as below?
<?php
$ParamContactID_WADAtblcontacts = "-1";
if (isset($_GET['ContactID'])) {
$ParamContactID_WADAtblcontacts = (get_magic_quotes_gpc()) ? $_GET['ContactID'] : addslashes($_GET['ContactID']);
}
$ParamSessionContactID_WADAtblcontacts = "-1";
if (isset($_SESSION['WADA_Insert_tblcontacts'])) {
$ParamSessionContactID_WADAtblcontacts = (get_magic_quotes_gpc()) ? $_SESSION['WADA_Insert_tblcontacts'] : addslashes($_SESSION['WADA_Insert_tblcontacts']);
}
$ParamContactID2_WADAtblcontacts = "-1";
if (isset($_GET['ContactID'])) {
$ParamContactID2_WADAtblcontacts = (get_magic_quotes_gpc()) ? $_GET['ContactID'] : addslashes($_GET['ContactID']);
}
mysql_select_db($database_ghl_portal, $ghl_portal);
$query_WADAtblcontacts = sprintf("SELECT ContactID, ContactFullName, ContactAddress1, ContactAddress2, ContactAddress3, ContactTown, ContactPostCode, ContactReferrelSource, ContactNotes, ContactAssignedTo FROM tblcontacts WHERE ContactID = %s OR ( -1= %s AND ContactID= %s)", GetSQLValueString($ParamContactID_WADAtblcontacts, "int"),GetSQLValueString($ParamContactID2_WADAtblcontacts, "int"),GetSQLValueString($ParamSessionContactID_WADAtblcontacts, "int"));
$WADAtblcontacts = mysql_query($query_WADAtblcontacts, $ghl_portal) or die(mysql_error());
$row_WADAtblcontacts = mysql_fetch_assoc($WADAtblcontacts);
$totalRows_WADAtblcontacts = mysql_num_rows($WADAtblcontacts);mysql_select_db($database_ghl_portal, $ghl_portal);
$query_WADAtblcontacts = "SELECT tblcases.CaseID, tblcontacts.ContactFullName, tblcontacts.ContactAssignedTo, tblcontacts.ContactTown, tblcontacts.ContactPostCode, tblcases.CaseCommission, tblcases.CaseType, tblcases.CaseDate, tblcases.CaseReferral, tblcases.CaseNotes, tblcases.CaseOfferedDate, tblcases.CaseCompletedDate, tblcases.CaseNPWDate, tblcontacts.ContactPostCode, tblcontacts.ContactEmail FROM tblcases INNER JOIN tblcontacts ON tblcases.ContactID = tblcontacts.ContactID;";
$WADAtblcontacts = mysql_query($query_WADAtblcontacts, $ghl_portal) or die(mysql_error());
$row_WADAtblcontacts = mysql_fetch_assoc($WADAtblcontacts);
$totalRows_WADAtblcontacts = mysql_num_rows($WADAtblcontacts);
?>