tritus Posted September 6, 2007 Share Posted September 6, 2007 i am making a news script for my site and i want to only pull the latest entry into the database... how do i do that? my code: <?php mysql_connect("localhost", "$db_user", "$dbpass"); mysql_select_db(tritusco_news); $sql = mysql_query("SELECT * FROM news"); while($result = mysql_fetch_array($sql)) { echo " <b>Date:</b> " .$result["date"] . "<br>"; echo " <b>Subject:</b> " .$result["subject"] . "<br>"; echo " <b>Body:</b> " .$result["body"] . " <br><br>----------------<br><br>"; } ?> Link to comment https://forums.phpfreaks.com/topic/68261-solved-how/ Share on other sites More sharing options...
GingerRobot Posted September 6, 2007 Share Posted September 6, 2007 Two options. 1.) Add a limit statement to your query: $sql = mysql_query("SELECT * FROM news LIMIT 1"); 2.) Dont use a while loop. Instead of: <?php while($result = mysql_fetch_array($sql)) { //code here } ?> Just do: <?php $result = mysql_fetch_array($sql); //code here ?> Link to comment https://forums.phpfreaks.com/topic/68261-solved-how/#findComment-343182 Share on other sites More sharing options...
darkfreaks Posted September 6, 2007 Share Posted September 6, 2007 <?php mysql_connect("localhost", "$db_user", "$dbpass"); mysql_select_db(tritusco_news); $sql = mysql_query("SELECT * FROM news"); $result = mysql_fetch_array($sql)) { echo " Date:$result['date']" ; echo " Subject:$result['subject'] . " ; echo " Body: $result['body'] " ; } ?> Link to comment https://forums.phpfreaks.com/topic/68261-solved-how/#findComment-343186 Share on other sites More sharing options...
tritus Posted September 6, 2007 Author Share Posted September 6, 2007 this grabs one, but it isnt the latest entry Two options. 1.) Add a limit statement to your query: $sql = mysql_query("SELECT * FROM news LIMIT 1"); 2.) Dont use a while loop. Instead of: <?php while($result = mysql_fetch_array($sql)) { //code here } ?> Just do: <?php $result = mysql_fetch_array($sql); //code here ?> Link to comment https://forums.phpfreaks.com/topic/68261-solved-how/#findComment-343188 Share on other sites More sharing options...
GingerRobot Posted September 6, 2007 Share Posted September 6, 2007 Forgot to add, you'll need an order by clause in your query. You could use the date field for that $sql = mysql_query("SELECT * FROM news ORDER BY date DESC LIMIT 1"); Link to comment https://forums.phpfreaks.com/topic/68261-solved-how/#findComment-343189 Share on other sites More sharing options...
tritus Posted September 6, 2007 Author Share Posted September 6, 2007 thanks for the help works!!! Link to comment https://forums.phpfreaks.com/topic/68261-solved-how/#findComment-343202 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.