externe Domain-Preisliste

// Make a MySQL Connection
mysql_connect("localhost", "user", "passwort") or die(mysql_error());
mysql_select_db("datenbank") or die(mysql_error());




function getDomains()
{
	$query = mysql_query("SELECT d.id, d.extension 'tld', t.type, c.code, c.suffix, t.msetupfee FROM tbldomainpricing AS d
    	INNER JOIN tblpricing AS t ON t.relid = d.id
    	INNER JOIN tblcurrencies AS c ON c.id = t.currency
    	WHERE t.type IN ('domainregister','domaintransfer','domainrenew') ORDER BY d.id ASC");
	$dataArray=array();
	while($row = @mysql_fetch_array($query, MYSQL_ASSOC)) {
    	$dataArray[$row['tld']][$row['type']]=$row;
	}
	return $dataArray;
}




$mydata = getDomains();
echo "<pre>mydata: " . print_r($mydata,TRUE) . "</pre>";
foreach($mydata as $k => $v) { // $k=TLD
	echo "<br />" . $k . ' - Register Price: ' .	$v['domainregister']['msetupfee'] . ' &euro;';	
}