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);
?>