Re: MySQL: problems with Select Count(Distinct)
| From: | Tom Churm | Date: | Tue, 09 Oct 2001 11:00:29 +0000 |
| Subject: | Re: MySQL: problems with Select Count(Distinct) | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-70443@lists.php.net to get a copy of this message | ||
hi dimitris:
it doesn't work-- i get the same error message:
"You have an error in your SQL syntax near 'distinct(SemName)) from
hr_form2;' at line 1"
thanks, though!
tom
Dimitris Kossikidis wrote:
>
> Try this...
>
> select count(distinct(SemName)) from hr_form2;
>
> ----- Original Message -----
> From: "Tom Churm" <thomas.churm@pixelpark.com>
> To: <php-general@lists.php.net>
> Sent: Tuesday, October 09, 2001 12:40 PM
> Subject: [PHP] MySQL: problems with Select Count(Distinct)
>
> > hi,
> >
> > i've checked and the same version of MySQL is on my test-server as on my
> > online server (3.23.22-beta).
> >
> > however, this simple query works on my test-server but NOT on my online
> > server:
> >
> > Select COUNT(DISTINCT SemName) FROM hr_form2
> >
> > i get this error message:
> > MySQL said: You have an error in your SQL syntax near 'DISTINCT SemName)
> > FROM hr_form2' at line 1
> >
> > many thanks if you can offer any suggestions!
> >
> > tom
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> > For additional commands, e-mail: php-general-help@lists.php.net
> > To contact the list administrators, e-mail: php-list-admin@lists.php.net
> >
> >