Need some advice...

I'm querying a law enforcement SQL database for records based on name. The way the database was setup allows for multiple entries of the same record so, when I run a query and loop through the records, I receive numerous instances of the same record. What I want is to be able to loop through the records and obtain only one instance of each record. Does anyone know of a way to filter out and display only one instance of the record using a date or id key?

Thanks in advance...

if the records are IDENTICAL you can use SQL and do a SELECT DISTINCT

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

Thanks! That worked like charm!

Chris

Glad that resolved the problem ^^

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile