Justtechjobs.com Find a programming school near you






Online Campus Both


php-windows | 2001051

Re: [PHP-WIN] Need someone with some experience From: Cynic (cynic <email protected>)
Date: 05/09/01

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 <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: php-windows-unsubscribe <email protected>
>For additional commands, e-mail: php-windows-help <email protected>
>To contact the list administrators, e-mail: php-list-admin <email protected>
------end of quote------

cynic <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: php-windows-unsubscribe <email protected>
For additional commands, e-mail: php-windows-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>