3v4l.org

run code in 150+ php & hhvm versions
Bugs & Features
<?php $yesterday = date('Y-m-d', strtotime("-1 days")); $sql = "SELECT fc.forum_id,count(fc.forum_id)as total_comments ". "FROM ForumComments as fc ". "WHERE $yesterday <= fc.updated_at ". "GROUP BY fc.forum_id ". "ORDER BY total_comments DESC "; echo($sql);
Output for 4.3.0 - 7.1.0
SELECT fc.forum_id,count(fc.forum_id)as total_comments FROM ForumComments as fc WHERE 2014-07-22 <= fc.updated_at GROUP BY fc.forum_id ORDER BY total_comments DESC