session_start(); if ($accesso=='on') {
include('../config.php');
echo "
$title\n";
echo "\n";
$sql="select * from ".$news." order by id_news desc";
$result=mysql_query($sql,$conn);
$i=0;
while ($datarecord=mysql_fetch_row ($result))
{$indice[$i]=$datarecord[0]; if ($datarecord[0]==$id) {$k=$i;}
$i++;
}
if ($azione=='up') {$id1=$indice[$k]; $id2=$indice[$k-1];}
if ($azione=='down') {$id1=$indice[$k]; $id2=$indice[$k+1];}
$sql="select * from ".$news." where (id_news ='$id1')";
$result1=mysql_query($sql,$conn);
$datarecord1=mysql_fetch_row ($result1);
$sql="select * from ".$news." where (id_news ='$id2')";
$result2=mysql_query($sql,$conn);
$datarecord2=mysql_fetch_row ($result2);
$sql="update ".$news." set data='$datarecord1[1]', titolo='".addslashes($datarecord1[2])."', descrizione='".addslashes($datarecord1[3])."', testo='".addslashes($datarecord1[4])."', tipo='$datarecord1[5]', lingua='$datarecord1[6]', foto='$datarecord1[7]', datain='$datarecord1[8]', dataout='$datarecord1[9]', argomento='$datarecord1[10]', ambito='$datarecord1[11]', importanza='$datarecord1[12]', align='$datarecord1[13]', home_pages='$datarecord1[14]', foto_home='$datarecord1[15]' where (id_news ='$id2')";
mysql_query($sql,$conn);
$sql="update ".$news." set data='$datarecord2[1]', titolo='".addslashes($datarecord2[2])."', descrizione='".addslashes($datarecord2[3])."', testo='".addslashes($datarecord2[4])."', tipo='$datarecord2[5]', lingua='$datarecord2[6]', foto='$datarecord2[7]', datain='$datarecord2[8]', dataout='$datarecord2[9]', argomento='$datarecord2[10]', ambito='$datarecord2[11]', importanza='$datarecord2[12]', align='$datarecord2[13]', home_pages='$datarecord2[14]', foto_home='$datarecord2[15]' where (id_news ='$id1')";
mysql_query($sql,$conn);
echo "
\n";
}
?>