Untitled

if($_GET['action']=="list")
{

$result_aktienliste = mysql_query("SELECT a.name, a.symbol, k.wkn,k.stamptime,k.kurswert,(SELECT k2.kurswert FROM kurs k2 WHERE k2.wkn=k.wkn AND k2.stamptime<UNIX_TIMESTAMP() ORDER BY k2.stamptime DESC LIMIT 1,1) AS altwert FROM kurs k, aktie a WHERE a.wkn=k.wkn AND stamptime=(SELECT stamptime FROM kurs WHERE stamptime<UNIX_TIMESTAMP() GROUP BY stamptime ORDER BY stamptime DESC LIMIT 1 ) ORDER BY a.name;");
if ($result_aktienliste) {
        while ($row = mysql_fetch_array($result_aktienliste)) {
                        print "\"".$row["name"]."\",\"".$row["symbol"]."\",\"".$row["wkn"]."\",".$row["kurswert"].",'".round(($row["kurswert"]-$row["altwert"]),2)."';\n\r";
        }
}
}else if($_GET['action']=="order")
{
echo "ORDER";
}else{
include("test.csv");
}