I am trying to generate a JSON formatted table using data from my database. When doing so, I get the error PHP Fatal error: Call to a member function fetch() on a non-object in G:\PleskVhosts\mywebsite.com\httpdocs\getData.php on line 23

(This is line 19 here)

I'm not sure why it's giving this error as I did something very similar on another page and it works pefectly fine. Here is my code.

<?

$db = new PDO("mysql:host=".$servername.";dbname=".$dbname.";", $username, $password);

$query = $db->query("SELECT 'MAJOR' as 'Major' SUM(IF(MAJOR = 'Computer Science',1,0)) as CS, SUM(IF(MAJOR = 'Computer Information Systems',1,0)) as CIS, SUM(IF(MAJOR = 'Other',1,0)) as Other FROM ages");



$table = array();
$table['cols'] = array(
    array('label' => 'Major', 'type' => 'string'),
    array('label' => 'CS', 'type' => 'number'),
    array('label' => 'CIS', 'type' => 'number'),
    array('label' => 'Other', 'type' => 'number')
);

$rows = array();
while($r = $query->fetch()){
    $temp = array();
    $temp[] = array('v' => $r['Major']);
    $temp[] = array('v' => (int) $r['CS']);
    $temp[] = array('v' => (int) $r['CIS']);
    $temp[] = array('v' => (int) $r['Other']);

    $rows[] = array('c' => $temp);
}

$table['rows'] = $rows;

$jsonTable = json_encode($table);

echo $jsonTable;


?>