kostenloser Webspace werbefrei: lima-city

in: Wlan in Ubuntu

geschrieben von sfs

in: Automatisch generierte Tabelle - Inhalte sortieren

geschrieben von sfs

<?php
$server     = '';
$benutzer   = '';
$passwort   = '';
$datenbank  = '';
//error_reporting(E_ALL);
//datenbank abfrage
mysql_connect($server, $benutzer, $passwort) OR die(mysql_error());
mysql_select_db($datenbank) OR die(mysql_error());
//---------------------------------------------------------------------------------------------------------
$sql = mysql_query("SELECT *
FROM `datensatz_rohstoffe`
WHERE `holz` =35")
or die(mysql_error());

$num_holz = mysql_num_rows($sql);
//-----------------------------------------------------------------------------------------------------
$sql = mysql_query("SELECT *
FROM `datensatz_rohstoffe`
WHERE `lehm` =35")
or die(mysql_error());

$num_lehm = mysql_num_rows($sql);
//-----------------------------------------------------------------------------------------------------
$sql = mysql_query("SELECT *
FROM `datensatz_rohstoffe`
WHERE `erz` =35")
or die(mysql_error());

$num_erz = mysql_num_rows($sql);
//-----------------------------------------------------------------------------------------------------
$sql = mysql_query("SELECT *
FROM `datensatz_rohstoffe`
WHERE `getreide` =35")
or die(mysql_error());

$num_getreide = mysql_num_rows($sql);
//-----------------------------------------------------------------------------------------------------
$sql = mysql_query("SELECT *
FROM `datensatz_rohstoffe`
WHERE `mehl` =75")
or die(mysql_error());

$num_mehl = mysql_num_rows($sql);
//-----------------------------------------------------------------------------------------------------
$sql = mysql_query("SELECT *
FROM `datensatz_rohstoffe`
WHERE `kohle` =93")
or die(mysql_error());

$num_kohle = mysql_num_rows($sql);
//-----------------------------------------------------------------------------------------------------
$sql = mysql_query("SELECT *
FROM `datensatz_rohstoffe`
WHERE `bretter` =93")
or die(mysql_error());

$num_bretter = mysql_num_rows($sql);
//-----------------------------------------------------------------------------------------------------
$sql = mysql_query("SELECT *
FROM `datensatz_rohstoffe`
WHERE `ziegel` =93")
or die(mysql_error());

$num_ziegel = mysql_num_rows($sql);
//-----------------------------------------------------------------------------------------------------
$sql = mysql_query("SELECT *
FROM `datensatz_rohstoffe`
WHERE `eisen` =207")
or die(mysql_error());

$num_eisen = mysql_num_rows($sql);
//-----------------------------------------------------------------------------------------------------
$sql = mysql_query("SELECT *
FROM `datensatz_rohstoffe`
WHERE `brot` =153")
or die(mysql_error());

$num_brot = mysql_num_rows($sql);
//-----------------------------------------------------------------------------------------------------
function ausgabe($job_ranking_func)
{
echo "<table border='0'>";
echo "<tr><th>Berufe Ranking</th><th>Punkte</th></tr>";
foreach($job_ranking_func as $name=>$wert)
echo "<tr><td>$name</td><td>$wert</td>";
echo "</table>";
}

$job_ranking["Holzf&auml;ller"]  = $num_holz;
$job_ranking["Lehmst&auml;cher"] = $num_lehm;
$job_ranking["Bergarbeiter"]     = $num_erz;
$job_ranking["Bauer"]            = $num_getreide;
$job_ranking["M&uuml;ller"]      = $num_mehl;
$job_ranking["K&ouml;hler"]      = $num_kohle;
$job_ranking["Schreiner"]        = $num_bretter;
$job_ranking["Ziegelbrenner"]    = $num_ziegel;
$job_ranking["Schmied"]          = $num_eisen;
$job_ranking["B&auml;cker"]      = $num_brot;

//sortiert nach werten absteigend
arsort($job_ranking, SORT_NUMERIC);
ausgabe($job_ranking);
?>