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
|
<!-- start News -->
<div class="row">
<div id="breakingNews" class="breaking-news mocked">
<div class="col-lg-3 text-right breaking-left">
<h2 class="responsive">
<span class="breaking-small">Flash</span><br>
<span class="breaking-large">News</span>
</h2>
</div>
<div class="col-lg-9 breaking-right">
<marquee behavior="scroll" direction="left"><p>
<?
//News
include("admin/setConn.php");
$special = new class_utility();
if ($db == FALSE)
die ("Errore nella connessione.");
$namedb = "Sql603025_1";
//PAGINE
$result = mysql_db_query($namedb, $sql, $db);
$count = mysql_query("SELECT COUNT(ID) FROM notiziebrevi");
$res_count = mysql_fetch_row($count);
$tot_records = $res_count[0];
$per_page = 200;
$tot_pages = ceil($tot_records / $per_page);
$current_page = (!$_GET['page']) ? 1 : (int)$_GET['page'];
$primo = ($current_page - 1) * $per_page;
//FINE PAGINE
if ($db == FALSE)
die ("Errore nella connessione.");
$sql = "SELECT * FROM notiziebrevi ORDER BY Data_e_ora, ID LIMIT $primo, $per_page";
$result = mysql_db_query($namedb, $sql, $db);
while($results = mysql_fetch_array($result)){
$ID = $results["ID"];
$testonews = $special->specialChars($results["Titolo"]);
}
$cate = "News";
$stringa = permalink($testonews);
echo "<A href='http://www.euroroma.net/".$ID."/".$cate.".html' class='news'>".$testonews."</A>";
//echo "<A href='news.php?ID=".$ID."&cat=News' class='news'>".$testonews."</A>";
mysql_close($db);
?>
</p></marquee>
<? echo "<A href='http://www.euroroma.net/".$ID."/".$cate.".html' class='news'>" ?>
<button type="button" class="btn btn-danger btn-xs">Leggi tutto...
<i class="glyphicon glyphicon-arrow-right"></i>
</button>
<? echo "</A>"; ?>
</div>
</div>
</div><!-- /row -->
<!-- end News -->
|