Re: Need someone with some experience

I guess it'd be fastest to collect those 500 rows into an array, and then do st. like this: * create an array of all the values of the critical column, * run array_count_values() on it, * take the keys which have value >1, * iterate the rows again, and if the critical column value in any iteration is in_array() of the keys, highlight the row. At 18:43 9.5. 2001, Asendorf, John wrote the following: -------------------------------------------------------------- >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 ------end of quote------ cynic@mail.cz ------------- And the eyes of them both were opened and they saw that their files were world readable and writable, so they chmoded 600 their files. - Book of Installation chapt 3 sec 7