Check multiple field to discard dupl.

[Anon]

Please help.

I'm a novice coder, and the person I'm writing this for keeps changing his mind about what he wants.

I need to be able to check 3 different fields of tab-delimited text to eliminate duplicates in the echo results.

The code which is working successfully to do so on one field is:

$alreadyfounds = array(); # Clear what we've already found...
for ($mycount = 0; $mycount < $entiredbcount; $mycount++) {
if ($entiredb[$mycount][7] != "") {
$checkagainst = $entiredb[$mycount][7];

                    if (($alreadyfounds[$checkagainst] != 1) && ($checkagainst != "")) 
                    { 
                    echo "<TR><TD VALIGN=top>"; 
                    echo $entiredb[$mycount][6]; 
                    if (trim($entiredb[$mycount][6]) != "") { 
                    echo " "; 
                    } 
                    echo $entiredb[$mycount][7]; 
                    echo "</TD>"; 

I need to be able to check field 6 and 7 together (i.e. 6 is Firstname, 7 is Lastname) and then really should also check field 20 (which is the URL if they have one) to eliminate duplicates only if the field is not blank.

Previously, I was using the following code to echo the record only if field 20 was not blank. (Those with no URL weren't listed at all...listing everybody is a newly requested feature!)

if ($entiredb[$mycount][20] != "") {
$checkagainst = $entiredb[$mycount][20];

                    if (($alreadyfounds[$checkagainst] != 1) && ($checkagainst != "")) 

Now I need to list all individuals, whether or not they have a URL, and eliminate all duplicates based on a concatenation of fields 6 and 7 and also on field 20.

I'm now so confused, I don't know if there's any logic left here or not.

Let's say I have "John Day" whose URL is http://daylight.com/

Now, Good old John may also have a listing under "John Day, Esq." with the same URL as on his John Day listing.

Ideally, I want to list John and his URL only once. BUT... If John had a different URL with "John Day, Esq.", i.e. http://dayesq.com , then I'd need to echo both listings for dear John.

Can anyone help, or is this so far gone that I should just submerge my head in the neighbor's hot tub for 15-20 minutes????

[mbariou]

I presume if somebody has several URL it's the same... A pseudo code answer

You create an array to store person
$person=Array();

you create an array for each person
$book[$NAME][$i]...0 -> $URL 1->$STUFF1 and so on

$book=array();=>$book[$NAME][$i]
$j=0;
while ($RECORD){// For each record text
$NAME=trim($first).trim($last)
stuff1=
stuff2=
...
$person[$j]=$NAME;
//I call stuff each field of a record //separated by a tab
$i=0;
while($stuff){
if(isset($stuff=trim ($stuff))){
$book[$NAME][$i]=$stuff;
}//Endif
$i++;
}Endwhile stuff
$j++;
}EndWhile Record
//Here remove duplicate person
$person =array_unique ($person)
//And Print result
while($person){
for each stuff :
{print $book[$$person][$i];}
}

 Have a nice day

Marcel

[Anon]

Thanks, Marcel.

I'll see if I can get this solution to work.

Actually, the URLs would not be to the same site...some of the subjects have one URL for one purpose, another for another purpose.

Anyway, I'll play around with your suggestion and see if I can create a workable solution.

Thanks so much.

Lenka

[mbariou]

Let me know the end of the story

LadyLoess wrote:

Thanks, Marcel.

I'll see if I can get this solution to work.

Actually, the URLs would not be to the same site...some of the subjects have one URL for one purpose, another for another purpose.

Anyway, I'll play around with your suggestion and see if I can create a workable solution.

Thanks so much.

Lenka