show blog entries as links

bfsog

I want to show the newest 5 posts (or newest entries) as a link.

<?php
include ("connect.php");
 $query = "SELECT id, title FROM content ORDER by id DESC LIMIT 5"; 
    $result = mysql_query($query); 
    $numrows = mysql_num_rows($result); 

while($row = mysql_fetch_array($result)) 
{ 
echo '<a href="articles.php?var="'.$row['id'].'">', $row['title'], '</a>';

$numrows++; 
    }
?>
    }

However, this dont work. I used that, and all the links came out as the same.

Any help?

ShawnK

I revised your code a bit:

<?php

include ("connect.php");
$query = mysql_query("SELECT id, title FROM content ORDER by id DESC LIMIT 5"); 

while( $row = mysql_fetch_array( $query ) ) 
{ 
   echo "<a href='articles.php?var=" . $row['id'] . "'>" . $row['title'] . "</a>";
}
?>

Your major mistake was right here:

echo '<a href="articles.php?var="'

When echoed it actully does this:

It cuts of the url right after var, so it never actully puts the right link.