[Jawelin]

Originally posted by Meirion
Do you have a problem with members registering several names that sound simillar?

In my experience when somebody registers and alternate alias they use a dodgy Hotmail account and a completely different name in order to not be traced.

As for grouping by function, dunno, is there a quick and dirty way of making a temporary table with these results in then doing a standard SELECT with a GROUP on that temp table?

FoA, thanks for such a fast answer.

Yes, I'm trying to findout possible dupe users (along with ip & pw) by an approximative check of username & email name...
I know well it'd be an 'empiric' way, but not too more than looking for dupe identical password, don't you agree ?

Hwr, a temp table seemed a good solution me too...
But, first I could do a little bit more precise job at php level with lot of memory used to sort the fetch_array; second I wouldn't mess up the db too much creating and destroying temp tables at runtime... Third, I have no idea of the performance and fragmentation impacts such a table could give.


Thank you again.
Bye