what would i add to this code to make it show only the most recent entry....

[jbrill]

Hey guys,

 

just wondering what i would add to the code below to only show the most recent entry. probably somethind like order by "startdate" and i would like it to only limit to one.

 

thanks,

 

 

<?php
$result = mysql_query("SELECT * FROM news WHERE CURDATE() BETWEEN startdate AND expdate;");
while($row = mysql_fetch_array($result))
  {
  echo "<p>" . $row['title'] . "</p>";
  echo "<p class=\"SWhiteText\">" . substr($row['content'],0,500) . "</p>";
   }
?>   

[BlueSkyIS]

SELECT * FROM news ORDER BY startdate DESC LIMIT 1