Jump to content

Show 4 most recent entires mysql timestamp


nharry

Recommended Posts

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++;

}

?>

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.