include_once("connection.php"); $ad = "SELECT Count(news1.Titulo) AS CountOfTitulo FROM news1"; $ab = odbc_exec ($connect,$ad); $group = odbc_result($ab,"CountOfTitulo") ; $sql = "SELECT * FROM news1 where id = $group"; $rs = odbc_exec ($connect,$sql); $a = odbc_result($rs,"titulo"); $ad2 = "SELECT Count(news2.Titulo) AS CountOfTitulo FROM news2"; $ab2 = odbc_exec ($connect,$ad2); $group2 = odbc_result($ab2,"CountOfTitulo") ; $sql2 = "SELECT * FROM news2 where id = $group2"; $rs2 = odbc_exec ($connect,$sql2); $a2 = odbc_result($rs2,"titulo"); $ad3 = "SELECT Count(news3.Titulo) AS CountOfTitulo FROM news3"; $ab3 = odbc_exec ($connect,$ad3); $group3 = odbc_result($ab3,"CountOfTitulo") ; $sql3 = "SELECT * FROM news3 where id = $group3"; $rs3 = odbc_exec ($connect,$sql3); $a3 = odbc_result($rs3,"titulo"); $ad4 = "SELECT max(id) AS CountOfTitulo FROM news4"; $ab4 = odbc_exec ($connect,$ad4); $group4 = odbc_result($ab4,"CountOfTitulo") ; $sql4 = "SELECT * FROM news4 where id = $group4"; $rs4 = odbc_exec ($connect,$sql4); $a4 = odbc_result($rs4,"titulo"); $a4_link = odbc_result($rs4,"link"); $ad5 = "SELECT max(id) AS CountOfTitulo FROM news5"; $ab5 = odbc_exec ($connect,$ad5); $group5 = odbc_result($ab5,"CountOfTitulo") ; $sql5 = "SELECT * FROM news5 where id = $group5"; $rs5 = odbc_exec ($connect,$sql5); $a5 = odbc_result($rs5,"titulo"); $a5_link = odbc_result($rs5, "link"); $ad6 = "SELECT max(id) AS CountOfTitulo FROM news6"; $ab6 = odbc_exec ($connect,$ad6); $group6 = odbc_result($ab6,"CountOfTitulo") ; $sql6 = "SELECT * FROM news6 where id = $group6"; $rs6 = odbc_exec ($connect,$sql6); $a6 = odbc_result($rs6,"titulo"); $a6_link = odbc_result($rs6,"link"); $sql = "SELECT id, link_title, document, category FROM announcements WHERE homepage='1' order by sort_order, link_title"; $result = odbc_exec ($connect,$sql); if ( odbc_num_rows( $result ) ) { while ( odbc_fetch_row( $result ) ) { $id = odbc_result($result, "id"); $link_title = odbc_result($result, "link_title"); $document = odbc_result($result, "document"); $category = odbc_result($result, "category"); if ($category == 'Announcement') { if ($document) $announcements_html .= "$link_title
"; } elseif ($category == 'News'){ if ($document) $news_html .= "
|