jbrill Posted May 9, 2007 Share Posted May 9, 2007 Hey, i posted yesterday about the project im working on.. (previous post: http://www.phpfreaks.com/forums/index.php/topic,139793.0.html ) my question is, how do i only show the 3 latest news releases. I just want to display the 3 most recent posts on the index and when they click news they will be able to view all of the previous news articles. Keep in mind i am new to php but am a quick learner. thanks again. Link to comment https://forums.phpfreaks.com/topic/50693-help-displaying-news-articles-from-database/ Share on other sites More sharing options...
pocobueno1388 Posted May 9, 2007 Share Posted May 9, 2007 You would just make a query that limits the results to 3 and order then in DESC order so you get the 3 latest posts. Then loop though them. $query = mysql_query("SELECT * FROM news ORDER BY id DESC LIMIT 3"); while ($row = mysql_fetch_assoc($sql)){ echo $row['subject'].'<br>' . $row['body'] . '<p>'; } Then obviously to display all the news posts, you would just get rid of the LIMIT in the query. Link to comment https://forums.phpfreaks.com/topic/50693-help-displaying-news-articles-from-database/#findComment-249203 Share on other sites More sharing options...
jbrill Posted May 9, 2007 Author Share Posted May 9, 2007 perfect works great. thanks Link to comment https://forums.phpfreaks.com/topic/50693-help-displaying-news-articles-from-database/#findComment-249296 Share on other sites More sharing options...
pocobueno1388 Posted May 9, 2007 Share Posted May 9, 2007 Awesome. Don't forget to click "solved" on this thread so no one gets confused. Link to comment https://forums.phpfreaks.com/topic/50693-help-displaying-news-articles-from-database/#findComment-249300 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.