$today = date("Y-m-d");
require ("up.php");
if ($sezioniID!="") {
$and=" and news_sezioniID='$sezioniID' ";
$sql1 = "SELECT * from sezioni where sezioniID='$sezioniID'";
//echo $sql1;
$result1 = mysql_query($sql1);
if($myrow1 = mysql_fetch_array($result1))
$title=$myrow1[sezioni_nome];
}
else {
$and=" ";
$title="Latest News";
}
include ("sopra.php");
if ($start=="" || $start==0) {
$sql1 = "SELECT * from news where news_data<='$today' $and order by newsID desc";
// echo $sql1;
$result1 = mysql_query($sql1);
$x=0;
if($myrow1 = mysql_fetch_array($result1)) {
$newsID= $myrow1[newsID];
$fatta= " newsID <>'$myrow1[newsID]' and ";
$titolo= $myrow1[news_titolo];
$sottotitolo= $myrow1[news_sottotitolo];
$news= $myrow1[news_news];
$immagine= $myrow1[news_immagine];
$titolo= $myrow1[news_titolo];
if ($immagine!="")
$immagine="
| ";
$data1=explode("-",$myrow1[news_data]);
?>
if(strlen($news)>600)
echo substr($news,0,600)."...";
else
echo $news;
?>
if(strlen($news)>600)
{
?>
}
?>
|
|
}
$start=0;
}
if($start==0)
$qta=5;
else
$qta=5;
$sql1 = "SELECT * from news where $fatta news_data<='$today' $and order by news_data desc, newsID desc limit $start,$qta";
$result1 = mysql_query($sql1);
$x=0;
?>
while($myrow1 = mysql_fetch_array($result1)) {
$data1=explode("-",$myrow1[news_data]);
?>
|
}
?>
$start=$start+$qta;
echo"";
$sql1 = "SELECT * from news where $fatta news_data<='$today' $and order by news_data desc, newsID desc limit $start,$qta";
$result = mysql_query($sql1);
if($start==9)
$start1=0;
else
$start1=$start-2*$qta;
if ($start!=$qta)
echo"$vocabolario[10] | ";
else
echo" | ";
if ($myrow = mysql_fetch_array ($result))
echo"$vocabolario[11] | ";
else
echo" | ";
echo"
";
include ("sotto.php");
?>
require ("down.php");
?>