PHP - All users email list

Not sure I'm new to this, but it was just to give it somewhere to start I guess :P

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;
 
Back