Re: php-mysql problem
| From: | itoctopus | Date: | Tue, 03 Apr 2007 13:03:35 +0000 |
| Subject: | Re: php-mysql problem | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-251973@lists.php.net to get a copy of this message | ||
$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@gmail.com> wrote in message
news:cea1d9ba0704030325r358a643bh638a3a79d635f97d@mail.gmail.com...
> 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 ?
>