[RESOLVED] PDO does not seem to work with MySQL's COUNT

[Phire]

I can't seem to get this query to work:

SELECT DISTINCT COUNT(*) from atable

I use PHP Data Objects (PDO) and when I prepare and execute this query, the resulting variable just equals "1". I can't use rowCount() because i'm using distinct. Removing distinct from the query makes no difference, it seems any count query just returns "1".

[NogDog]

What DBMS is being used? Got any source code we can see?

[Phire]

The code is not really complex at all, there really isn't much to show. Instead of trying to prepare the statement, I used the query function instead (just replaced the word prepare for query), and that works. Can anyone else use PDO to prepare SQL statements that return nothing but a count?

[NogDog]

Works for me:

<?php
try
{
   $db = new PDO('mysql:dbname=test;host=localhost', '*****', '*****');
   $stmt = $db->prepare('SELECT DISTINCT COUNT(*) AS my_count FROM products');
   $stmt->execute();
   $stmt->bindColumn('my_count', $count);
   $stmt->fetch();
   echo $count;
}
catch(Exception $e)
{
   print_r($e);
}
?>

[Phire]

It was indeed an error in my code. I was attempting to do: $result = $stmt->execute(); and doing $result->fetch();. execute() returns back an integer of the resulting operation (true or false).