{"id":1274,"date":"2022-08-30T15:15:10","date_gmt":"2022-08-30T15:15:10","guid":{"rendered":"https:\/\/unknownerror.org\/index.php\/2013\/11\/10\/zend-db-count-not-working-collection-of-common-programming-errors\/"},"modified":"2022-08-30T15:15:10","modified_gmt":"2022-08-30T15:15:10","slug":"zend-db-count-not-working-collection-of-common-programming-errors","status":"publish","type":"post","link":"https:\/\/unknownerror.org\/index.php\/2022\/08\/30\/zend-db-count-not-working-collection-of-common-programming-errors\/","title":{"rendered":"Zend DB – Count(*) not working-Collection of common programming errors"},"content":{"rendered":"

My sql statement is not working with Zend, its complaining about the Count(*) field… what am I doing wrong?<\/p>\n

\/\/ get open\/closed\n$stmt = $db->query('SELECT status, count(*) as total FROM reported_issues WHERE date_reported >= '.$today.' AND status IN (0,1) GROUP BY status');\nwhile ($row = $stmt->fetch())\n{\n    switch ($row['status'])\n    {\n        case 0:\n                $totalIssuesToday = $row['total'];\n                break;\n\n        case 1:\n                $totalIssuesClosedToday = $row['total'];\n                break;\n    }\n}\n<\/code><\/pre>\n
and the errors…<\/p>\n
Fatal error: Uncaught exception 'Zend_Db_Statement_Exception' with message\n'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Y' in 'where clause''\nin C:\\xampp\\htdocs\\dating\\trunk\\library\\Zend\\Db\\Statement\\Pdo.php:238\n\nStack trace:\n#0 C:\\xampp\\htdocs\\dating\\trunk\\library\\Zend\\Db\\Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array)\n#1 C:\\xampp\\htdocs\\dating\\trunk\\library\\Zend\\Db\\Adapter\\Abstract.php(484): Zend_Db_Statement->execute(Array)\n#2 C:\\xampp\\htdocs\\dating\\trunk\\library\\Zend\\Db\\Adapter\\Pdo\\Abstract.php(235): Zend_Db_Adapter_Abstract->query('SELECT status, ...', Array)\n#3 C:\\xampp\\htdocs\\dating\\trunk\\html\\siteadmin.php(59): Zend_Db_Adapter_Pdo_Abstract->query('SELECT status, ...')\n#4 {main} thrown in C:\\xampp\\htdocs\\dating\\trunk\\library\\Zend\\Db\\Statement\\Pdo.php on line 238\n<\/code><\/pre>\n
    \n
  1. \n
    The complaint is actually about the WHERE<\/code> — looks like your $today<\/code> variable does not contain what you think it should. Specifically, since it says:<\/p>\n
    'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Y' in 'where clause''\n<\/code><\/pre>\n
    it seems your variable contains a Y<\/code> that shouldn’t be there. The count<\/code> appears to have nothing to do with the issue.<\/p>\n<\/li>\n
  2. \n
    Aside from what others have noted about the value you have in $today, you really should be using bound parameters with your queries<\/p>\n<\/li>\n<\/ol>\n
    Originally posted 2013-11-10 00:13:40. <\/small><\/p>","protected":false},"excerpt":{"rendered":"
    My sql statement is not working with Zend, its complaining about the Count(*) field… what am I doing wrong? \/\/ get open\/closed $stmt = $db->query(‘SELECT status, count(*) as total FROM reported_issues WHERE date_reported >= ‘.$today.’ AND status IN (0,1) GROUP BY status’); while ($row = $stmt->fetch()) { switch ($row[‘status’]) { case 0: $totalIssuesToday = $row[‘total’]; […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1274","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/1274","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=1274"}],"version-history":[{"count":0,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/1274\/revisions"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=1274"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=1274"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=1274"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}