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. Quote 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. Quote 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 Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.