a quick query Help me please

[scotte]

I want to write a query so that it finds and shows me if there are more than 3 orders by the same person. I was thinkg

WHERE email_id appears more than 3 times show me their account_id.

BTW would insert this into a php page

How would i write that in query form???

Many thanks

Scott

[barand]

Try

$sql = "SELECT account_id, email_id, COUNT(*) as total
          FROM mytable
          GROUP BY account_id, email_id
          HAVING total > 3";

$res = mysql_query($sql);

if (list($account, $email, $total) = mysql_fetch_row($res)) 
{
     do {
           echo "$account<br>";
     } while (list($account, $email, $total) = mysql_fetch_row($res));
}
else {
        echo "No accounts with more than 3 orders<br>";
}

[scotte]

Thankyou so much i am very grate ful