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>"; } ?> Quote Link to comment 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 ?> Quote Link to comment 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'] " ; } ?> Quote Link to comment 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 ?> Quote Link to comment 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"); Quote Link to comment Share on other sites More sharing options...
tritus Posted September 6, 2007 Author Share Posted September 6, 2007 thanks for the help works!!! Quote Link to comment 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.