On 4/3/07, Me2resh Lists <[EMAIL PROTECTED]> 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 ?

$SQL = "SELECT EMail,count(EMail) AS repeated FROM mena_guests WHERE
Voted = 'yes' GROUP BY EMail ORDER BY count(EMail)  LIMIT

I can't remember if in the order clause you can order by the alias of
the field or using the count again, test it to see what's the proper

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to