include("header.php"); ?>
$sql = "select * from categoria where categoriaID = 1";
$result = mysql_query($sql);
if ($myrow = mysql_fetch_array($result)) {
echo "
".$myrow[categoria_titolo]."
";
$sqlschede = "select * from scheda s, categoria c, join_scheda_categoria j where j.join_schedaID=s.schedaID and j.join_categoriaID=c.categoriaID and c.categoriaID = 1 and s.scheda_pubblicata='Y' order by s.scheda_priorita, s.scheda_titolo";
$resultschede = mysql_query ($sqlschede);
if ($myrowschede = mysql_fetch_array($resultschede)) {
$link="";
do {
$link .= "- $myrowschede[scheda_titolo]
";
} while ($myrowschede = mysql_fetch_array($resultschede));
echo $link;
}
echo "
";
}
include("news.php");
?>
Archivio Notizie
$sql = "select * from news where news_tipo='news' and news_data
sql = $sql; // the (basic) sql statement (use the SQL whatever you like)
$result = $test->get_page_result(); // result set
$num_rows = $test->get_page_num_rows(); // number of records in result set
$nav_links = $test->navigation(" | ", "currentStyle"); // the navigation links (define a CSS class selector for the current link)
$nav_info = $test->page_info("a"); // information about the number of records on page ("to" is the text between the number)
$simple_nav_links = $test->back_forward_link(true); // the navigation with only the back and forward links, use true to use images
$total_recs = $test->get_total_rows(); // the total number of records
for ($i = 0; $i < $num_rows; $i++)
{
$titolo = mysql_result($result, $i, "news_titolo");
$data = mysql_result($result, $i, "news_data");
$id = mysql_result($result, $i, "newsID");
$d_h = explode(" ",$data);
$dat = explode("-", $d_h[0]);
$data = $dat[2]."/".$dat[1]."/".$dat[0]." ".$d_h[1];
$abstract = mysql_result($result, $i, "news_abstract");
echo "";
echo "";
echo $data;
echo " - ";
$abs = str_replace ("
", "", $abstract);
$abstract = str_replace ("
", "", $abs);
echo $abstract;
echo "";
}
echo "".$nav_links."
";
?>
include("banner.php"); ?>
include("legg.php"); ?>
include("footer.php"); ?>