<?php
$mysqlhost="localhost";
$mysqluser="xxxxx";
$mysqlpwd="xxxxx";
$mysqldb="xxxxx";

$connection=mysql_connect($mysqlhost, $mysqluser, $mysqlpwd) or die ("Verbindungsversuch fehlgeschlagen");

    mysql_select_db($mysqldb, $connection) or die("Konnte die Datenbank nicht waehlen.");

  	$sql = "SELECT p.products_id,
		           pd.products_id,
				   p.products_model,
				   pd.language_code,
				   pd.products_name,                                                  
				   FORMAT(p.products_quantity, 0) AS products_quantity,   
				   FORMAT(p.products_price, 2) AS products_price                      
				   FROM xt_products AS p, xt_products_description AS pd 
				   WHERE p.products_id = pd.products_id
				   AND pd.language_code = 'DE'
				   AND p.products_quantity < 999
				   ";
	        
    $adressen_query = mysql_query($sql) or die("Anfrage nicht erfolgreich");
?>

<Table width="100%">
<tr valign="bottom">
<td><h1>Warenbestand</h1>

Datum:
<?php
	$timestamp = mktime(8,55,0,1,10,2012);
	$datum = date("d.m.Y",$timestamp);
    $uhrzeit = date("H:i",$timestamp);
    echo $datum," - ",$uhrzeit," Uhr";
	
    $anzahl = mysql_num_rows($adressen_query);
    echo " | Anzahl der Artikel: $anzahl";
    ?> 
| <strong>
<?php
$wert = mysql_query("SELECT SUM(p.products_price*p.products_quantity) FROM xt_products");
echo "Warenbestand/-wert: $wert EUR";
?>
</strong> ...

<?php
$wert = mysql_query("SELECT SUM(p.products_price*p.products_quantity) FROM xt_products");
echo "Warenbestand/-wert: $wert EUR";
?>

<?php
$wert = mysql_query("SELECT SUM(products_price*products_quantity)");
echo "Warenbestand/-wert: $wert EUR";
?>

<?php

    $mysqlhost=""
    $mysqluser=""
    $mysqlpwd=""
    $mysqldb=""

    $connection=mysql_connect($mysqlhost, $mysqluser, $mysqlpwd) or die ("Verbindungsversuch fehlgeschlagen");

    mysql_select_db($mysqldb, $connection) or die("Konnte die Datenbank nicht waehlen.");

  	$sql = "SELECT p.products_id,
		           pd.products_id,
				   p.products_model,
				   pd.language_code,
				   pd.products_name,                                                  
				   FORMAT(p.products_quantity, 0) AS products_quantity,   
				   FORMAT(p.products_price, 2) AS products_price                      
				   FROM xt_products AS p, xt_products_description AS pd 
				   WHERE p.products_id = pd.products_id
				   AND pd.language_code = 'DE'
				   AND p.products_quantity < 999
				   ORDER BY products_name ASC
				   ";
	        
    $adressen_query = mysql_query($sql) or die("Anfrage nicht erfolgreich");
?>

<table width="100%">
<tr valign="bottom">
<td><h1>Warenbestand</h1>

Warenwert:

<?php
$wert = "SELECT FORMAT(SUM(FORMAT(products_price, 2)*products_quantity), 2) as summe FROM xt_products";

$result = mysql_query($wert);

if (!$result) {
    echo "Konnte Abfrage ($sql) nicht erfolgreich ausführen von DB: " . mysql_error();
    exit;
    }

if (mysql_num_rows($result) == 0) {
    echo "Keine Zeilen gefunden, nichts auszugeben, also Ende";
    exit;
    }

while ($row = mysql_fetch_assoc($result)) {
    echo $row["summe"];
    }

mysql_free_result($result);
?>

<table>
    <tr>
	<td>ID</td><td>Artikel-Nummer</td><td>Artikel-Name</td><td>Standard-Preis</td><td>Bestand</td>
	</tr>
	
	<?php
    while ($adr = mysql_fetch_array($adressen_query)){
    ?>

    <tr>
    <td align="right"><?=$adr['products_id']?></td>
    <td align="right"><?=$adr['products_model']?></td>
    <td><?=$adr['products_name']?></td>
	<td align="right"><?=$adr['products_price']?> &euro;</td>
    <td align="right"><?=$adr['products_quantity']?></td>
    </tr>

    <?php
    }
    ?>
</table>