Zusammen fassen lassen

//Zält wieviele Kartenamen in der Datenbank eingetragen wurden
$abfrage = "
SELECT
	COUNT(sprache)
FROM
	karte
WHERE
	karte.rarity = '1'";
$ergebnis = mysql_query($abfrage);
$menge = mysql_fetch_row($ergebnis);
$karte_name_menge = $menge[0];




$query = "
SELECT
	karte_name.db_name_de	AS knDE,
	karte_name.db_name_en	AS knEN,

	karte.rarity,
	karte.setnumber			AS kaSE,
	karte.db_sell,
	karte.sprache			AS kaSR,

	edition.short			AS edSH,

	sprache.short			AS spSH,

	rarity.name				AS raNA,

	quality.name_prim		AS quNP,

	auflage.db_name_de		AS auSH

FROM
	karte
INNER JOIN
	karte_name
		ON
			karte_name.id = karte.nameid
INNER JOIN
    edition
        ON
            edition.id = karte.edition
INNER JOIN
    sprache
        ON
            sprache.id = karte.sprache
INNER JOIN
    rarity
        ON
            rarity.id = karte.rarity
INNER JOIN
    quality
        ON
            quality.id = karte.quality
INNER JOIN
    auflage
        ON
            auflage.id = karte.db_auflage
WHERE
	karte.rarity = '1'
ORDER BY
	karte.db_sell,
	karte_name.db_name_de
";
$rs = mysql_query($query) OR die("Error: ".mysql_error()."</ br> Zeile ".__LINE__);
while($row = mysql_fetch_array($rs)) {
	echo "" . $karte_name_menge . "x&nbsp;";
	echo "" . kartenname($row['knDE'], $row['knEN'], $row['kaSR']) . "&nbsp;";
	echo "" . $row['edSH'] . "-";
	echo "" . $row['spSH'];
	echo "" . $row['kaSE'] . "&nbsp;|&nbsp;";
	echo "" . $row['raNA'] . "&nbsp;|&nbsp;";
	echo "" . $row['quNP'] . "&nbsp;|&nbsp;";
	echo "" . $row['auSH'] . "</br>";
}