* Ilic > >>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.
COUNT(DISTINCT was introduced in version 3.23.2: <URL: http://www.mysql.com/doc/N/e/News-3.23.2.html > Maybe your server is a bit old...? -- Roger --------------------------------------------------------------------- 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