\n";
echo "";
$files = db_select("home", "title, introtext");
if(!$files) return;
for($j=count($files)-1; $j>=0; $j--){ $f = $files[$j]; }
echo "\n";
echo "\n";
echo "\t".$f["title"]." | \n";
echo "\t".$f["introtext"]." | \n";
echo "
---|
\n";
echo "\n";
echo " ";
ht_rule();
echo " ";
if ( isset($ok)){
$ne=ht_a("homeedit.php", "Τροποίηση Εισαγωγικού Κειμένου Αρχικής Σελίδας", "Τροποίηση Εισαγωγικού Κειμένου Αρχικής Σελίδας");
echo $ne;
echo "
<< Πίσω";
}
echo "\n\n";
//---------------------------------------------------------------- NEWS -------------------------------------------------------------
//$query="SELECT title, filename, filetype, filesize, directory, ddate";
//$query.=" FROM announcement";
//$query.=" UNION ALL(SELECT title, filename, filetype, filesize, directory, ddate FROM olmenews)";
//$query.=" ORDER BY ddate DESC LIMIT 0 , 15";
// echo $query;
$query="create view viewX(title, filename, filetype, filesize, directory, ddate)";
$query.="as";
$query="SELECT title, filename, filetype, filesize, directory, ddate";
$query.=" FROM announcement";
$query.=" union ";
$query.="SELECT title, filename, filetype, filesize, directory, ddate FROM olmenews";
$query.=" WHERE category = '1' or category = '2' or category = '3'or category = '6'";
$query.=" ORDER BY ddate DESC LIMIT 0 , 15";
//echo $query;
$res=db_exec($query);
if(db_rows($res)!=0){
for($i=0; $i
| |