I am inclined to think (actually guess) it may be the version of MySQL you
are using. I am using MySQL 3.23.39 and I am able to successfully execute:
select count(distinct field) or select count(distinct(field))
I tried to make a quick check of the docs to see if a certain version was
required but I was unable to find anything.
----Original Message Follows----
From: Ilic <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Re: count(distinct
Date: Wed, 9 Jan 2002 14:54:12 +0100
Il Tue, 08 Jan 2002 13:23:09 -0500, Stephen Abshire andava dicendo...
>>SELECT count(distinct ip) FROM pole_voti
>>
>>It does'nt work. Why ?
>>
>>PhpMyAdmin says: You have an error in your SQL syntax near
>>'distinct ip)
>>FROM pole_voti' at line 1
>I don't have MySQL on the computer I am on to test this but you
>might try rewriting it this way:
>
>select count(distinct(ip)) from pole_voit
Already done. It does'nt work to.
Ilic.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
