Displaying unique emails in a table ... no duplicates 1

[sbayter]

Hi,
I have a table that record the history of visits in a page.
It saves the email address stored in the cookie everytime the user goes there.
I want to create a page that displays all the unique emails, no duplicates.
Thanks,

sbayter

 

[philclare]

use SELECT DISTINCT in the query...

$query = "SELECT DISTINCT email FROM ..."



Hope this helps,

Phil Clare

http://www.trinipoint.co.uk