title: Why does the count of an ADODB count result display differently on Virt. Dedic. Hosted site differently than other sites I've worked with?
body: <p>When not using symfony, I use adodb for querying databases. I have all of the queries that would be executed in a file. Each select statement is accompanied with its select count statement and am using binding parameters. So I make sure there is a count and if the count is zero, the appropriate error message is displayed. If there is a count greater than zero, then the select statement is performed. On my hosting and other shared hosting sites, the select count gives me a value and I use substr to get the count, but on my client's virtual dedicated server w/plesk, something weird happens. Here is an Example below:</p>
  
  <pre><code>$selectcountsql = "select count(*) from thistable where email = ? and pwdhash = ?";
  $selectcountquery = $db-&gt;Execute($selectcountsql,array($email,$pwdmashed));
  $count = substr($selectcountquery,10);
  </code></pre>
  
  <p>On other clients' sites w/shared hosting, the output of $count is an integer that is the actual count of records. 
  However, on my client's site hosted on Virtual Dedicated Hosting, when I:</p>
  
  <ol>
  <li>echo the $selectcountquery variable, it displays the value as COUNT(*) 1 --e.g. if count of 1 record returned.</li>
  <li>echo the $count variable, it displays nothing.</li>
  <li>when I chance $count to be substr($selectcountquery,5) , and echo it I get the word: Object</li>
  <li>when I print_r or dump the values of $selectcountquery, I get an array of many adodb variables.</li>
  </ol>
  
  <p>Do you have an idea as to what may be happening?</p>