[RESOLVED] Select statement where two fields are the same

[reeksy]

Hi

Quick problem. We've had people register in a database (we have 999 rows to date) however there wasn't a block to stop people registering with the same email address.

I want to run a query on the table that returns rows where an email address appears more than once.

Is this possible?

PHP 4 / MySQL 4

Jon

[Piranha]

I assume that you already know how to handle queries from PHP. Then you can do it like this:

$sql = "SELECT mail FROM table HAVING COUNT(mail) > 1 GROUP BY mail;";

That will give yu the mail addresses. To get the id from everyone that have the same addess you can use something simular to this:

//Loop through the result for the query above
    $sql2 = "SELECT id, mail FROM table HAVING mail = '" . $row['mail'] . "';";
    // Get the result and do a second loop to handle the result

I hope this helps.

[reeksy]

OK great. Thanks for your help - resolved