- Joined
- Apr 4, 2009
- Messages
- 898
- Reaction score
- 157
Not sure I'm new to this, but it was just to give it somewhere to start I guess![]()
It'll start in the order that the data was added to the database, the ORDER BY clause is not a requirement in a SELECT query.
Or restrict Emails from duplication in the beginning u start ur server.
Or use a while() and a double select query, but thats just odd. blows ur mind out if u are going to think about it.
Using a loop is a bad idea, and it's assumed that duplicates exist in the database from the start; the DISTINCT keyword is the quickest and easiest way to remove duplicate emails, used like so:
Code:
SELECT DISTINCT Email FROM Account;

