SELECT blogs.id, blogs.date_created, blogs.blogName, blogs.blogDetails, blogs.allowComments FROM blogs JOIN items_to_category,category WHERE items_to_category.item = blogs.id && category.id GROUP BY blogs.id ORDER BY str_to_date(date_created, '%d/%m/%Y %H:%i') DESC Blog
Get a Quote Today
SELECT * FROM blog_comments WHERE blog_id = AND approved = '1' ORDER BY date_createderror retrieving commentsYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND approved = '1' ORDER BY date_created' at line 1