[!--quoteo(post=371789:date=May 6 2006, 06:42 PM:name=Barand)--][div class=\'quotetop\']QUOTE(Barand @ May 6 2006, 06:42 PM) [snapback]371789[/snapback][/div][div class=\'quotemain\'][!--quotec--] Asuming each record has a unique auto_incrementing id column, then for all articles (latest first) [code]$sql = "SELECT id, title FROM articles ORDER BY id DESC";[/code] for latest x articles to be displayed [code]$x = 10; $sql = "SELECT id, title FROM articles ORDER BY id DESC LIMIT $x";[/code] For the read more bit, output a link containing the id of the record in the querystring [code]echo "a href='showmore.php?id=$id>Read more...</a>";[/code] [/quote] Thanks and is that code auto going to connect to the right database?