0) {
$s=mysql_fetch_assoc($res);
$htmlHead = <<< NEWS
{$item['title']}
{$item['des']}
NEWS;
} else
$htmlHead = <<< NEWS
{$item['title']}
{$item['des']}
NEWS;
$sql='SELECT f.file,f.ID,filetype ';
$sql.='FROM new_tablefiles t,new_files f ';
$sql.="WHERE t.tablename='new_news' AND t.tableID={$_GET['ID']} " ;
$sql.='AND f.ID=t.fileID ';
$sql.="AND filetype='gallery' ";
$sql.='ORDER BY filetype ';
$res=mysql_query($sql);
$nr=mysql_num_rows($res);
if($nr>0) {
$htmlGallery = '';
if($nr>1) {
$htmlGallery .= <<< NEWS
Photo Gallery
NEWS;
} else {
$htmlGallery .= <<< NEWS
Photo
NEWS;
}
}
while($s=mysql_fetch_assoc($res)) {
$sql='SELECT f.ID ';
$sql.='FROM new_tablefiles t,new_files f ';
$sql.="WHERE t.tablename='new_news' AND t.tableID={$_GET['ID']} " ;
$sql.='AND f.ID=t.fileID ';
$sql.="AND f.refID={$s[ID]} ";
$sql.="AND filetype='bigimg' ";
$r=mysql_query($sql);
if(mysql_num_rows($r)>0) {
$it=mysql_fetch_assoc($r);
$htmlGallery .= <<< NEWS

NEWS;
} else
$htmlGallery .= <<< NEWS

NEWS;
}
$htmlNews=$htmlHead;
if(! empty($htmlGallery))
$htmlNews.=$htmlGallery.'
';
} else {
$sql="INSERT INTO Log_table(ip_address, page_html, dateandtime_log) VALUES('{$_SERVER['REMOTE_ADDR']}', 'news', now())";
mysql_query ($sql);
$sql='SELECT * FROM new_news WHERE duedate >= now()' ;
$res=mysql_query($sql);
if(mysql_num_rows($res)>0) {
$htmlNews='';
while($item=mysql_fetch_assoc($res)) {
$id=$item['ID'];
$htmlNews .= <<< ROW
- {$item['title']}
ROW;
}
$htmlNews.='
';
}
$htmlNews .= <<< ROW
A man, a thought on the wire ...
off the wire,
the thought flies
this is SAEE world.
Click on the picture to see last advertising for SAEE products on most common italian electronic reviews
ROW;
}
?>
..:: SAEE - News ::..