Hmmm, that's what is troubling me so much, I have tried countless times to do that but it returns "MySQL Error 1054: Unknown column in 'tblreferral.RefferalID' on WHERE clause" even after ensuring both param are named differently, sql code is below
mysql_select_db($database_ghl_portal, $ghl_portal);
$query_rsDetail = sprintf("SELECT tblreferral.RefferalID, tblreferral.ReferralName, Count(tblcases.CaseID) As Cases, tblcasestatus.CaseStatusName
FROM tblcases Inner Join tblcontacts On tblcontacts.ContactID = tblcases.ContactID Inner Join tblreferral On tblreferral.RefferalID =
tblcontacts.ContactReferrelSource Inner Join tblcasestatus On tblcasestatus.CaseStatusID = tblcases.CaseStatusName
WHERE tblreferral.RefferalID=%s GROUP BY tblreferral.RefferalID, tblcasestatus.CaseStatusName
UNION All
SELECT '', 'GRAND-TOTAL', Count(tblcases.CaseID),''
FROM tblcontacts Inner Join tblcases On tblcontacts.ContactID = tblcases.ContactAssignedTo
WHERE tblreferral.RefferalID=%s",
GetSQLValueString($ParamReferralID_rsDetail, "int"),GetSQLValueString($ParamReferralID2_rsDetail, "int"));
Also tried removing the Parameter to use WHERE tblreferral.RefferalID=$_GET['ReferralID'] with no success.