nharry Posted March 26, 2010 Share Posted March 26, 2010 I have a movie database similar to imdb and I want to display the last 4 created entries. I have a column in my table for timestamp called 'dateadded'. How would I add it to this code??? Show 4 most recent entries to table <?php //connect to database mysql_connect($mysql_hostname,$mysql_user,$mysql_password); @mysql_select_db($mysql_database) or die("<b>Unable to connect to specified database</b>"); //query databae $query = "SELECT * FROM movielist"; $result=mysql_query($query) or die('Error, insert query failed'); $row=0; $numrows=mysql_num_rows($result); while($row<$numrows) { $id=mysql_result($result,$row,"id"); $imgurl=mysql_result($result,$row,"imgurl"); $imdburl=mysql_result($result,$row,"imdburl"); ?> <div class="moviebox rounded"><a href="http://<?php echo $domain; ?>/viewmovie?movieid=<?php echo $id; ?>" rel="facebox"> <img src="<?php echo $imgurl; ?>" /> <form method="get" action=""> <input type="text" name="link" class="link" style="display:none" value="http://us.imdb.com/Title?<?php echo $imdburl; ?>"/> </form> </a></div> <?php $row++; } ?> Link to comment https://forums.phpfreaks.com/topic/196620-show-4-most-recent-entires-mysql-timestamp/ Share on other sites More sharing options...
JonnoTheDev Posted March 26, 2010 Share Posted March 26, 2010 SELECT * FROM movielist ORDER BY dateadded DESC LIMIT 4 Link to comment https://forums.phpfreaks.com/topic/196620-show-4-most-recent-entires-mysql-timestamp/#findComment-1032331 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.