Hi,
Wel I tried you sugestion but it was not working.
Got error 'You have an error in your SQL syntax near 'null GROUP BY email'
The required result should be when some email was more than 1 time entered.
But your 'email not null' give me a hint to look a bit closer.
Also your request for script was not so bad, but its a mail list and some data inside should then also helpfull.
Some data? 🙁
Well that was the solution. I am working on a server in germany and at home a mirror in the netherlands.
Well synchronizing the tables so my local MySQLyog and MySQL CC have the same data as in germany is a
very good behaviour I think and that was the solution why phpAdmin(in germany after all) worked and the other 2 not.
Stupid me.
But many thanks for your reaction, it did help 🙂
Nero