The Many Facets of
Anthroposophy in the News
To see a subset of this Article list, you may enter a keyword and/or a
category you are interested in below. Click on the Show Links
button to view your selection. The "Hits" column represents the number
of times users have selected this link. The Links at the top and bottom
of the table will help you navigate through the pages of articles. There
are 20 articles displayed on every page, and the number of pages varies
depending on Category. Click here to see a list of
e.Libd News Items.
|
EOF;
if($category) {
if($category=="All") {
$tline=" | | Description | Category | Hits |
|---|
\n";
$query="select $urlTbl.uid,$urlTbl.url,$urlTbl.short_name,$urlTbl.description,$urlTbl.category,$urlTbl.hits_total,$urlTbl.stat,$urlTbl.source,$urlTbl.dline,date_format($urlTbl.dline, '%W %M %D, %Y') as fdline,$urlTbl.fb,$urlTbl.img,$urlTbl.timestamp,$catTbl.seq from $catTbl, $urlTbl where ($urlTbl.url like '%$keyword%' or short_name like '%$keyword%' or $urlTbl.description like '%$keyword%') and $catTbl.name = $urlTbl.category order by $urlTbl.dline desc, $urlTbl.short_name";
//echo "$query
\n";
$result=mysqli_query($mySQL_ID,$query) or die("Query failed: " . mysqli_error($mySQL_ID));
$num = mysqli_num_rows($result);
} else {
$tline="| $category | Category | Hits |
|---|
\n";
$query="select $urlTbl.uid,$urlTbl.url,$urlTbl.short_name,$urlTbl.description,$urlTbl.category,$urlTbl.hits_total,$urlTbl.stat,$urlTbl.source,$urlTbl.dline,date_format($urlTbl.dline, '%W %M %D, %Y') as fdline,$urlTbl.fb,$urlTbl.img,$urlTbl.timestamp,$catTbl.seq from $catTbl, $urlTbl where ($urlTbl.url like '%$keyword%' or short_name like '%$keyword%' or $urlTbl.description like '%$keyword%') and category='$category' and $catTbl.name = $urlTbl.category order by $urlTbl.dline desc, $urlTbl.short_name";
//echo "$query
\n";
$result=mysqli_query($$mySQL_ID,query) or die("Query failed: " . mysqli_error($mySQL_ID));
$num = mysqli_num_rows($result);
}
$rec_per_page=20;
$scroll=5;
$page=new Page(); ///creating new instance of Class Page
$page->set_qry_string("category=".$category);
$page->set_page_data($this_page,$num,$rec_per_page,$scroll,true,false,true);
$pgnav=$page->get_page_nav("",true);
$result=@mysqli_query($mySQL_ID,$page->get_limit_query($query));
$i=0;
echo <<
$pgnav
$tline
EOF;
while($row=mysqli_fetch_assoc($result)) {
$uid=$row["uid"];
$url=$row["url"];
$shname=$row["short_name"];
$description=$row["description"];
// $shname=mb_convert_encoding($row["short_name"], "UTF-8", "ISO-8859-1, windows-1252");
// $description=mb_convert_encoding($row["description"], "UTF-8", "ISO-8859-1, windows-1252");
$category=$row["category"];
$hits_total=$row["hits_total"];
$stat=$row["stat"];
$source=$row["source"];
$fdline=$row["fdline"];
$fb=$row["fb"];
$img=$row["img"];
// echo "|$stat|\n";
if("_$stat" != "_D") continue;
$imglnk=""; if($img) $imglnk=<<
EOF;
echo <<
$imglnk
$shnam
$description
($fdline — $source)
|
$category |
$hits_total |
EOF;
}
echo " \n";
echo $pgnav."\n";
}
// close link to database
if($usePersistentConnects == 0) mysqli_close($mySQL_ID);
echo <<
|
EOF;
include("/home/rsarchive/Steiner/Banners/display-kn160.php");
echo << |
|
|
|
|
|