teşekkür ederim aşağıdaki şekilde hallettim..
<?php
$db = mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("zd",$db) or die(mysql_error());
$result = mysql_query("SELECT * FROM defter ORDER BY id DESC",$db);
while ($yaz = mysql_fetch_array($result))
echo "$yaz[mesaj]<br>";
$result2 = mysql_query("SELECT * FROM ayarlar",$db);
while ($yaz2 = mysql_fetch_array($result2))
echo "<br>$yaz2[sifre]<br>";
?>