Hello,
I try your SQL statements. There is no problem on your SQL syntax
and you can use alias in the order by clause.:)
$SQL = "SELECT EMail,count(EMail) AS repeated FROM mena_guests WHERE
Voted = 'yes' GROUP BY EMail ORDER BY repeated LIMIT
$startingID,$items_numbers_list";
--
Rep
On 4/3/07, Me2resh Lists <[EMAIL PROTECTED]> wrote:
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 co
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 ?
On Tue, Apr 17, 2001 at 05:52:53PM -0400, Peter J. Krawetzky wrote:
> How do you move the database files to another location in MySQL? I am
> running Redhat 7.1 with MySQL version 3.23.33.
You ask the appropriate list @ [EMAIL PROTECTED]
Of course by the time you do so, you have already searc
How do you move the database files to another location in MySQL? I am
running Redhat 7.1 with MySQL version 3.23.33.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrator
