mysql_connect("localhost","root","");
mysql_select_db("denemeler");
		
$sql = mysql_query("SELECT baslik,kimlik_no FROM yazar_yazi ORDER BY tarih DESC");
while ( $row = mysql_fetch_assoc($sql) )
{
$sql2 = mysql_query("SELECT kullanici FROM yazarlar WHERE id='".$row['kimlik_no']."'");
$row2 = mysql_fetch_assoc($sql2);
echo $row['baslik'].' - '.$row2['kullanici'].'<br>';
}