At 6:50 PM +0000 6/19/1999, Sean McKenna wrote:
>On Sat, 19 Jun 1999 10:41:37 +0100, you wrote:
>
>>use DBI;
>>$dbh=DBI->connect("DBI:mysql:$db:$hostname:$port",$username, $password);
>>
>>$statement="SELECT DISTINCTROW province
>>FROM PROVINCES
>>GROUP BY province
>>ORDER BY province";
>>$sth=$dbh->prepare($statement);
>>$sth->execute;
>>
>
>I had not seen DISTINCTROW before, I always use DISTINCT.
>
>DISTINCTROW does not work for me, but DISTINCT does just fine.
DISTINCTROW seems to have been added between MySQL 3.21 and 3.22.
--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/
