Hmmm, using "distinct email" in a query where you want
to count email won't work.
select mail, count(mail) as mailcnt from guest
group by mail
order by mailcnt;
should do the trick.
On Tue, April 3, 2007 12:51, Me2resh Lists wrote:
> i need help regarding a sql query in my php app.
> the query is :
> $SQL = "SELECT DISTINCT(EMail) FROM mena_guests WHERE Voted = 'yes'
> LIMIT $startingID,$items_numbers_list";
> i want to sort this query by the number of the repeated EMail counts.
> can anyone help me with that please ?
> This message has been scanned for viruses and
> dangerous content by OpenProtect(http://www.openprotect.com), and is
> believed to be clean.
+45 40 85 71 38
+66 870 133 224
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.
|• mysql question.||Me2resh Lists||3 Apr|
| • Re: mysql question.||Mogens Melander||3 Apr|