title: SQL sum query not working not working. Returning NULL
body: <p>Im trying to obtain the sum of used channels. can anyone see what is wrong with my code?<br />
  $spacefreenvr variable returns nothing (blank) when result should be 144 from the 3 rows in the database.</p>
  <pre><code>$nvrlisting = $con-&gt;prepare(&quot;SELECT SUM(usedchannel) AS usedchan FROM CCTVequip WHERE customer LIKE ? AND equipserial LIKE ?&quot;);
  $filtertype = &quot;NVR%&quot;;
  $nvrlisting-&gt;bind_param('ss', $camclient, $filtertype);
  $nvrlisting-&gt;execute();
  $spacecount = $nvrlisting-&gt;fetch(PDO::FETCH_ASSOC);
  $spacefreenvr = $spacecount['usedchan'];
  $nvrlisting-&gt;close();
  </code></pre>