|
|
|
|
|||||||||||||||||||||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
Double results??
Hello all,
I am running the following queryI 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 FRM caa44240 WHERE caa442400018 = '$case_id'"; if ($case_category == "CJ") { $name_query.="AND caa44240002 = 'C' AND caa44240003 = '1'"; } if ($case_category == "CF" || "MM" || "CT" || "TR" || "M" || "IN" || "C") { $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 |
![]() |
| Viewing: Web Development Archives > Mailing Lists > PHP > Double results?? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|