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 - [EMAIL PROTECTED]
>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: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
------end of quote------
[EMAIL PROTECTED]
-------------
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
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
