$sorgu = mysql_query("SELECT * FROM sonaranan ORDER BY id ASC LIMIT 10"); while ( $cek = mysql_fetch_array($sorgu) ) { $id = $cek['id']; $aranan = $cek['aranan']; echo '<a href="arananlar.php?id='.$id.'">'.$aranan.'</a>'; }