Month Archives

WARNING: Could not execute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESC' at line 6: SELECT DATE_FORMAT( added, '%M %Y' ) AS get_month, DATE_FORMAT( added, '%Y%m' ) AS get_monthx, COUNT(entry_id) AS num_entry FROM blog WHERE is_public > 0 AND added <= DATE_ADD(CURRENT_TIMESTAMP(), INTERVAL 5 HOUR) GROUP BY get_monthx DESC

WARNING: mysqli_free_result() expects parameter 1 to be mysqli_result, null given

Category Archives

WARNING: Could not execute query. Table 'my_lovesupreme.blog_category' doesn't exist: SELECT j.cat_id, c.fl_subject AS cat_name, COUNT(b.entry_id) AS num_entry FROM blog_catjoin j JOIN blog b ON j.entry_id=b.entry_id LEFT JOIN blog_category c ON j.cat_id=c.fl_id WHERE b.is_public > 0 AND b.added <= DATE_ADD(CURRENT_TIMESTAMP(), INTERVAL 5 HOUR) GROUP BY j.cat_id ORDER BY c.fl_subject ASC

WARNING: mysqli_free_result() expects parameter 1 to be mysqli_result, null given