Hallo,
ich berechne anhand der Geburts-Sterbedaten das Alter eines Grabsteins,
http://www.grosspeterwitz.de/friedhof/4images/alteste_lukas.phpleider stimmt die abwärts Sortierung nicht,
zur Zeit sortiere ich die Ausgabe mittels SQL "ORDER BY image_alter desc LIMIT 0,25" in der Zeile 51
wie bekomme ich es hin, dass die errechnete $ausgabe nach
$alter sortiert wird. sehe Zeile 76
"ORDER BY image_alter desc" muss gelöscht werden, aber weiter komme ich nicht.........
sort_desc ($alter)???????????
@Rembrandt wäre schön wenn du mir da einen kleinen Tipp geben könntest,
MFG
<?php
/**************************************************************************
* *
* 4images - A Web Based Image Gallery Management System *
* ---------------------------------------------------------------- *
* *
* File: alteste.php *
* Copyright: (C) 2002-2009 Jan Sorgalla *
* Email: jan@4homepages.de *
* Web: http://www.4homepages.de *
* Scriptversion: 1.7.9 *
* File Version: 1.0.0 (by Rembrandt www.vienna-pictures.com) *
* Never released without support from: Nicky (http://www.nicky.net) *
* *
**************************************************************************
* *
* Dieses Script ist KEINE Freeware. Bitte lesen Sie die Lizenz- *
* bedingungen (Lizenz.txt) für weitere Informationen. *
* --------------------------------------------------------------- *
* This script is NOT freeware! Please read the Copyright Notice *
* (Licence.txt) for further information. *
* *
*************************************************************************/
$main_template = 'statistic'; // <-- Your Template Title
define('GET_CACHES', 1);
define('ROOT_PATH', './');
define('MAIN_SCRIPT', __FILE__);
include(ROOT_PATH.'global.php');
require(ROOT_PATH.'includes/sessions.php');
include(ROOT_PATH.'includes/page_header.php');
$txt_clickstream = $lang['statistic_page_title'];
$verstorbene = $lang['verstorbene'];
$geboren_stat = $lang['geboren_stat'];
$gestorben_stat = $lang['gestorben_stat'];
$geborene = $lang['geborene'];
$anklicken = $lang['anklicken']; // <-- Clickstream Name
$zginol= $lang['zginol'] ;
$gefallen= $lang['gefallen'] ;
//################## EXAMPLE CUSTOM PHP CODE STARTS HERE ############################
$imgtable_width = ceil((intval($config['image_table_width'])) / $config['image_cells']);
if ((substr($config['image_table_width'], -1)) == "%") {
$imgtable_width .= "%";
}
$sql = "SELECT ((substr(i.image_gestorbenGP,7,4)) - (substr(i.image_geboren,7,4))) AS image_alter, i.image_gefallenam,i.image_gestorbenGP,i.image_geboren, i.image_id, i.cat_id, i.user_id, i.image_name,i.image_active, i.image_media_file, i.image_thumb_file
FROM (".IMAGES_TABLE." i, ".CATEGORIES_TABLE." c)
WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND image_gestorbenGP LIKE '%%.%%.%%%%' AND image_geboren LIKE '%%.%%.%%%%'
ORDER BY image_alter desc LIMIT 0,25
";
$result = $site_db->query($sql);
$liste = "<table style=\"text-align:center;\" width=\"".$config['image_table_width']."\" border=\"0\" cellpadding=\"".$config['image_table_cellpadding']."\" cellspacing=\"".$config['image_table_cellspacing']."\">\n";
$liste .= "<tr><td class=\"title4\">Die 25 ältesten Peterwitzer.</td></tr>";
$liste .= "</table>";
$liste .= "<table width=\"".$config['image_table_width']."\" border=\"0\" cellpadding=\"".$config['image_table_cellpadding']."\" cellspacing=\"".$config['image_table_cellspacing']."\">\n";
$count = 0;
$bgcounter = 0;
$ausgabe="";
$config['image_cells'] = 1;
while ($image_row = $site_db->fetch_array($result)) {
$datum_gestorben = explode(".",$image_row['image_gestorbenGP']);
$datum_geboren = explode(".",$image_row['image_geboren']);
$alter = ($datum_gestorben[2]) - ($datum_geboren[2]);
if (($datum_gestorben[1]) < ($datum_geboren[1]) || ($datum_gestorben[1] == ($datum_geboren[1]) && ($datum_gestorben[0]) < ($datum_geboren[0]))) {
$alter--;
}
$ausgabe = ($alter >= 0) ? "Mit <b>".$alter."</b> Jahren ist <b>".$image_row['image_name']."</b> ".$gestorben_stat."" :"";
if(!empty($ausgabe)){
if ($count == 0) {
$row_bg_number = ($bgcounter++ % 2 == 0) ? 1 : 2;
$liste .= "<tr class=\"imagerow".$row_bg_number."\">\n";
}
$liste .= "<td width=\"".$imgtable_width."\" valign=\"top\"><a href=\"./details.php?image_id=".$image_row['image_id']."\"onmouseover=\"Tip('<b>".$anklicken."</b><br><br><CENTER><img src=\'./data/media/".$image_row['cat_id']."/".$image_row['image_media_file']."\' width=\'300\' ></CENTER><br>')\" onmouseout=\"UnTip()\" >".$ausgabe."</td>\n";
$liste .= "</tr>\n";
$count++;
if ($count == $config['image_cells']) {
$liste .= "</tr>\n";
$count = 0;
}
}
}// end while
$liste .= "</table>\n";
$content = $liste;
unset($liste);
//-----------------------------------------------------
//--- Clickstream -------------------------------------
//-----------------------------------------------------
$clickstream = "<span class=\"clickstream\"><a href=\"".$site_sess->url(ROOT_PATH."index.php")."\" class=\"clickstream\">".$lang['home']."</a>".$config['category_separator'].$txt_clickstream."</span>";
//-----------------------------------------------------
//--- Print Out ---------------------------------------
//-----------------------------------------------------
$site_template->register_vars(array(
"content" => $content,
"msg" => $msg,
"clickstream" => $clickstream,
"lang_statistic_page_title" => $lang['statistic_page_title']
));
$site_template->print_template($site_template->parse_template($main_template));
include(ROOT_PATH.'includes/page_footer.php');
?>