mja Posted November 17, 2008 Share Posted November 17, 2008 Hello everybody. Im working on a cms, where I have to show a preview of the last two articles of all the categories, on the frontpage. The article is saved in mysql and shown in php. DB looks like this: article_id,author,title,category,date(timestamp) Does anybody know how the query should be? Link to comment https://forums.phpfreaks.com/topic/133056-help-with-query/ Share on other sites More sharing options...
revraz Posted November 17, 2008 Share Posted November 17, 2008 Just do a query with a LIMIT 2. Do your ORDER BY Date DESC. Link to comment https://forums.phpfreaks.com/topic/133056-help-with-query/#findComment-692051 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.