Re: Need someone with some experience

John If what you are really after is to display any records where a given field is duplicated, then I would say that a self join is the best bet. If you just pull 500 consecutive records out into an array, and perform the comparrisoon in php, then what happens if record 500 has a duplicate to record 1001 - you will never compare the two? Also, unless you particularly want to look at all of the records, if you do a self join on the field that you suspect could have duplicates, then you need only display those records that are suspect. Tom "Asendorf, John" wrote: > I'm about to create a piece of a project which which will be used to check > for errors in data entry. Every 500 records entered will prompt the user to > check their work. I have all of the triggers set up already. The database > is all Oracle, PHP 4.0.4 (1381 build). What I would like to do is display > all of the 500 records (no problem) and (here's where I could use some > advice) highlight any records with a duplicate value in one particular > field. > > Should I load all of the data into an array? Should I skim through all the > records, take notes, reset, and then run through them again? Should I run a > separate statement which searches for dupes and then match them against the > whole body of records? > > I don't want code, just a voice of experience which could start me off > right. > > Thanks, > > John > > --------------------- > John Asendorf - jasendorf@lcounty.com > Web Applications Developer > http://www.lcounty.com - NEW FEATURES ADDED DAILY! > Licking County, Ohio, USA > 740-349-3631 > Aliquando et insanire iucundum est > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > For additional commands, e-mail: php-windows-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net