$sql = "SELECT count(Email) as numEmails, Email FROM mena_guests WHERE Voted='yes' GROUP BY Email ORDER BY numEmails DESC LIMIT $startingID, $items_numbers_list"; -- itoctopus - http://www.itoctopus.com ""Me2resh Lists"" <me2resh.lists@xxxxxxxxx> wrote in message news:cea1d9ba0704030325r358a643bh638a3a79d635f97d@xxxxxxxxxxxxxxxxx > hi > 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 ? > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
