Hello all,
I am running the following query...I get the results I want, but for some
reason I am getting every valid result twice?
Any ideas?
$name_query = "SELECT caa44240002, caa44240003, caa44240004, caa442400018
FROM caa44240
WHERE caa442400018 = '$case_id'";
if ($case_category == "CJ") {
$name_query.="AND caa44240002 = 'C'
AND caa44240003 = '1'";
}
if ($case_category == "CF" || "MM" || "CT" || "TR" || "MO" || "IN" ||
"CO") {
$name_query.="AND caa44240002 = 'D'
AND caa44240003 = '1'";
}
$name_result = ifx_query ($name_query, $connect_id);
while ($name = ifx_fetch_row($name_result)) {
$party_name = TRIM($name['caa44240004']);
print_r($name);
}
print_r($name) will return:
John
John
Mary
Mary
Cindy
Cindy