|
|
|
";
for ($i=0;$i<$num;$i++) {
$category_number=mysql_result($res_category, $i, "category_number");
#=======# English = language='1'
$max_id="SELECT MAX(id) AS max_id FROM news WHERE news.category_number='$category_number' AND language='1'";
$res_max_id=mysql_query($max_id, $link);
$max_id=mysql_result($res_max_id, 0, "max_id");
//echo $max_id;
#=======# English = news.language='1'
$content="SELECT news.datum, news.file_name, news.headline, news.news_short, news.external_link, news.external_link_text, news.internal_link, news.internal_link_text, category.english FROM news, category WHERE news.language='1' AND news.id='$max_id' AND category.category_nr='$category_number'";
$res_content=mysql_query($content, $link);
$datum=mysql_result($res_content, 0, "datum");
$file_name=mysql_result($res_content, 0, "file_name");
$headline=mysql_result($res_content, 0, "headline");
$news_short=mysql_result($res_content, 0, "news_short");
$external_link=mysql_result($res_content, 0, "external_link");
$external_link_text=mysql_result($res_content, 0, "external_link_text");
$internal_link=mysql_result($res_content, 0, "internal_link");
$internal_link_text=mysql_result($res_content, 0, "internal_link_text");
$german=mysql_result($res_content, 0, "english");
if ($external_link!="") {
$news_link="$external_link_text";
}
else {
if ($category_number==1) {
$news_link="$headline";
$archiv_link="Factoring News Archive";
}
if ($category_number==2) {
$news_link="$headline";
$archiv_link="Accounts Receivable News Archive";
}
if ($category_number==3) {
$news_link="$headline";
$archiv_link="Purchase Order News Archive";
}
if ($category_number==4) {
$news_link="$headline";
$archiv_link="Venture Capital News Archive";
}
if ($category_number==5) {
$news_link="$headline";
$archiv_link="Disaster Relief News Archive";
}
}
$news_short=nl2br($news_short);
echo " |
