|
|
if(!isset($idnews)) {
$query="SELECT idnews FROM ".TABLE_NEWS." WHERE data<'".date("Y-m-d")."' ORDER BY data DESC LIMIT 0,1";
$results=mysql_query($query);
$row=mysql_fetch_array($results);
$idnews=$row['idnews'];
}
$query="SELECT * FROM ".TABLE_NEWS." WHERE idnews=".$idnews;
$results=mysql_query($query);
$row=mysql_fetch_array($results);
?>
echo $row['titolo']; ?>
echo $row['periodo']; ?>
$img="archivio/prodotti/".$row['idnews']."/".$row['img'];
if($row['img']!=""&&file_exists($img)) {
echo '';
}
?>
echo $row['testo']; ?>
if($row['pdf']!="") echo 'Scarica il PDF';
?>
|
$query="SELECT * FROM ".TABLE_NEWS." WHERE data<='".date("Y-m-d")."' AND datafine>='".date("Y-m-d")."' ORDER BY data";
$results=mysql_query($query);
while($row=mysql_fetch_array($results)) {
?>- echo ''.$row['periodo'].'
'.$row['titolo']; ?>
}
?>
|
|
|