3v4l.org

run code in 300+ PHP versions simultaneously

sponsor
bughunt
search
recent
about

@ 2014-07-23T04:17:01Z

<?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
Performance
VLD
References
Branches

date: documentation ( source)
strtotime: documentation ( source)

preferences:dark modelive preview

38.96 ms | 402 KiB | 5 Q