$sorgu = mysql_query("SELECT s.no AS odenmis
FROM siparis AS s
	INNER JOIN odeme AS o ON (o.no = s.odemeNo)
WHERE o.durum = 1");
$odenmisler = array();
while ($satir = mysql_fetch_assoc($sorgu))
	$odenmisler[] = $satir['odenmis'];
mysql_free_result($sorgu);

foreach ($odenmisler as $odenmis)
	echo $odenmis, '<br />';