webosb

ack.. I just ended up exporting a csv file and then i filtered all the columns with excel... thanks for the help everyone. i appreciate it.

I kept getting an error from the mysql_query part... can I accomplish this without the use of php?

i cant seem to figure out how i can do this but this is what i need done. I have 3 fields: id, rating, and ip sample format: id | rating | ip 1 | 10 | 1.2.3.4 1 | 10 | 1.2.3.4 1 | 10 | 1.2.3.4 1 | 10 | 1.2.3.4 1 | 10 | 1.3.2.4 1 | 10 | 1.1.2.2 I need a query to remove all duplicate ips for rating 10 for id 1 so the above sample will end up like this: id | rating | ip 1 | 10 | 1.2.3.4 1 | 10 | 1.3.2.4 1 | 10 | 1.1.2.2 please note that id ranges from 1-1000 and rating ranges anywhere from 1 to 10 so I need a query to remove dupe ip's from ratings 1-10 for each id