";
$NavNames = array( $sSiteTitle );
$NavLinks = array( "index.php" );
$sHeader = "";
//$sHeader2 = "We are not only ASP programmers - we are webmasters as well!";
if($main_category != "")
$only_this_category = "am_faq.name = '$main_category' AND ";
else
$only_this_category = "";
$oRS = mysql_query( "select answer,question, thumbnail, am_question.date as faq_date, am_question.author as faq_author, am_question.fldAuto as qid, am_faq.fldAuto as faqid, am_faq.name as faqname, am_chapter.name as chaptername, am_question.link1, am_question.descrizionelink1 FROM am_faq ,am_chapter, am_question WHERE am_faq.name = 'News' AND am_question.evidence = 1 AND am_question.chapter_fldAuto=am_chapter.fldAuto AND am_chapter.faq_fldAuto=am_faq.fldAuto AND am_question.date IS NOT NULL
ORDER BY am_question.date desc, am_question.fldAuto LIMIT 0,1" );
$row=mysql_fetch_array($oRS);
$FAQDate2 = (isset($row["faq_date"]))? my_date_format($row["faq_date"]) : "";
$link2 = "showquestion.php?fldAuto=" . $row["qid"] . "&faq=". $row["faqid"];
$linkM = (isset($row["link1"]))? "".$row["descrizionelink1"]."" : "";
$sContent .= "
|
";
$oRS = mysql_query( "select answer,question, thumbnail, am_question.date as faq_date, am_question.author as faq_author, am_question.fldAuto as qid, am_faq.fldAuto as faqid, am_faq.name as faqname, am_chapter.name as chaptername, am_question.link1, am_question.descrizionelink1 FROM am_faq ,am_chapter, am_question WHERE $only_this_category am_question.chapter_fldAuto=am_chapter.fldAuto AND am_question.evidence != 1 AND am_chapter.faq_fldAuto=am_faq.fldAuto order by am_question.orderingfield desc LIMIT 0,$max_homepage_news" );
$j=0;
while ( $row=mysql_fetch_array($oRS) ) {
$ChapterName = $row["chaptername"];
$FAQName = stripslashes($row["faqname"]);
$sThumbnail = $row["thumbnail"];
if(isset($row["faq_date"])) $FAQDate = $row["faq_date"];
if(isset($row["faq_author"])) $FAQAuthor = stripslashes($row["faq_author"]);
$Question = stripslashes($row["question"]);
$Answer = $row["answer"];
$linkM = (isset($row["link1"]))? "".$row["descrizionelink1"]."" : "";
if (IsValidWebsite($Answer))
$Answer = "";
else
$Answer = substr($Answer, 0, $NumeroCaratteriNews) . "...";
if(!isset($FAQDate) || $FAQDate == "")
$FAQDate = "";
else
$FAQDate = my_date_format($FAQDate);
if(!isset($FAQAuthor) || $FAQAuthor == "")
$FAQAuthor = "";
else
$FAQAuthor = ">> ".$FAQAuthor;
$link = "showquestion.php?fldAuto=" . $row["qid"] . "&faq=". $row["faqid"];
$ArticleData = "".$Answer."
".$linkM;
if ($j%2==0){$tro="";$trc="";}
else {$tro="";$trc="
";}
$sContent .= $tro."";
if($sThumbnail != ""&&$j<$max_homepage_news_short)
$sContent .= "";
$sContent .="";
if($j<$max_homepage_news_short)
$sContent .= stripslashes($ArticleData)." ";
$sContent .= " | ".$trc ;
unset($FAQDate);
unset($FAQAuthor);
$j++;
}
if($j%2!=0){
$sContent .= " | ";
}
$sContent = $sContent . "";
WriteContent( $conn, $NavNames, $NavLinks, $sContent, $sHeader);
?>