PDO Object is NULL

[Korferer]

 
My code;

$sql = "SELECT SUM(IF(`submitdate` IS NULL , 1 , 0 )) as 'Survey Started But Not Completed' FROM `survey_$surveyid`";
$statement = $dbh->prepare($sql);
$statement->execute();
$result = $statement->fetch(PDO::FETCH_OBJ); //pass that data to an object

Is returning;
 

stdClass Object
(
    [Survey Started But Not Completed] => 
)


I need to set this to a vaule that I can actually print out on the screen... Like a "0" for example. At the moment it is just a NULL.
 
How do I do this??
 
These don't work;
 

$result  = 0;

$result = array(['Survey Started But Not Completed'] => "0");

 

[requinix]

Rather than SUM+IF, I'd use COUNT which will only count non-null values.

SELECT COUNT(`submitdate`) AS 'Survey Started But Not Completed' FROM `survey_$surveyid`

Side comment: tsk tsk for using multiple tables for multiple surveys. Should be just one table for everything.

Edited July 31, 2014 by requinix