1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
|
<? session_start();
if(!array_key_exists('user', $_SESSION))
{
header("Location: index.php");
exit;
}
?>
<html>
<head>
<link rel="stylesheet" href="../style.css" type="text/css" media="screen" />
<title></title>
</head>
<body>
<div id="container">
<div id="content">
<TABLE width="100%" border="0">
<TR>
<TD valign="top">
<TABLE>
<TR>
<td height="50"><H1><? echo str_replace("_", " ", $_GET['nomecat']); ?></H1></td>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
<?
include("../setConn.php");
include("../class_utility.php");
$special = new class_utility();
$namedb = "Sql603025_1";
if ($db == FALSE)
die ("Errore nella connessione.");
$sql = "SELECT * FROM spalladestra WHERE ID=2";
$result = mysql_db_query($namedb, $sql, $db);
$i=0;
while($results = mysql_fetch_array($result)){
$IDarticolo = $results["IDarticolo"];
if($IDarticolo==0){
echo "<p><A HREF='cerca1.php?ID=".$results["ID"]."&nomecat=SPALLA_DESTRA_2'>SELEZIONA ARTICOLO...</A></p>";
}
$sfondo="fotobianca";
if ( $i % 2 == 0 ) {
$sfondo="fotoblu";
}
if ($db == FALSE)
die ("Errore nella connessione.");
$sql2 = "SELECT * FROM risultati WHERE ID=".$IDarticolo;
$result2 = mysql_db_query($namedb, $sql2, $db);
while($results2 = mysql_fetch_array($result2))
{
echo "<DIV class=".$sfondo.">";
echo "<TABLE width='98%' cellpadding='0' cellspacing='0'><TR><TD>";
echo "<p class='data'>".$results2["Data_e_ora"]."</p>";
echo "<DIV align='justify'><B>".$special->specialChars($results2["Rubrica"])."</B></DIV>";
if($results2["URLimg"]){
echo "<DIV align='justify'><IMG SRC='".$results2["URLimg"]."'></DIV>";
}
echo "<DIV align='justify'>".$special->specialChars($results2["Titolo"])."</DIV>";
echo "<DIV align='justify'>".$special->specialChars($results2["Sottotitolo"])."</DIV>";
echo "<DIV><A HREF='cerca1.php?ID=".$results["ID"]."&nomecat=SPALLA_DESTRA_2'><IMG SRC='../mod.jpg' WIDTH='20' HEIGHT='30' BORDER='0' ALT='Modifica'></A>";
echo " ";
echo "<A HREF='del.php?ID=".$results["IDarticolo"]."&nomecat=SPALLA_DESTRA_2'><IMG SRC='../cancella.jpg' WIDTH='20' HEIGHT='30' BORDER='0' ALT='Elimina'></A>";
echo " ";
echo "</DIV>";
echo "</TD></TR></TABLE>";
echo "</DIV>";
echo "<!-- RIGA -->";
echo "<hr>";
}
echo "<p><A HREF='cerca1.php?ID=".$results["ID"]."&nomecat=SPALLA_DESTRA_2'>SELEZIONA ARTICOLO...</A></p>";
$i++;
}
include("../paginazione.php");
mysql_close($db);
?>
</div>
</div>
</body>
</html>
|