remove multiple entries from database

[Anon]

i`m a beginner to php and i have a problem sorting the mysql table.

i want to sort all data in the mysql database like this:

$abfrage = "SELECT jahr,monat,tag,vorname,nachname,email,lowscore from gewinnspiel where monat like '$month' ORDER BY lowscore LIMIT 0, 999";

but then i want to remove all duplicate "email" rows.

first:

email lowscore
[e-mail] 225
[e-mail] 285
[e-mail] 295
[e-mail] 300

after sorting the table schould look like this:

[e-mail] 225
[e-mail] 300

hope you can help me - thanx

[[deleted]]

You cannot simply 'ignore' duplicate data.
yes, you can do things like distinct and GROUP BY, but in MySQL those f*ck up pretty good.

The best thing you can do is run a query like this:

SELECT MIN(recordid), email
FROM table
WHERE monat = $month
GROUP BY email;

This will return the record ids (I assume you have a Primary key in that table) of the first entry by each unique email.

You can use that list to fetch the rest of the data.