include('include/config.php'); include('scripts/php/functions.php'); $query_news = "SELECT * FROM news WHERE active = 1 ORDER BY `order` ASC, id_news DESC LIMIT 4"; $news = mysql_query($query_news, $conn) or die(mysql_error()); $row_news = mysql_fetch_assoc($news); $totalRows_news = mysql_num_rows($news); $query_testimonials = "SELECT * FROM testimonials WHERE active = 1 ORDER BY `order` ASC, id_testimonials DESC LIMIT 2"; $testimonials = mysql_query($query_testimonials, $conn) or die(mysql_error()); $row_testimonials = mysql_fetch_assoc($testimonials); $totalRows_testimonials = mysql_num_rows($testimonials); $query_news_home = "SELECT * FROM news WHERE active = 1 AND home = 1 ORDER BY `order` ASC, id_news DESC LIMIT 1"; $news_home = mysql_query($query_news_home, $conn) or die(mysql_error()); $row_news_home = mysql_fetch_assoc($news_home); $totalRows_news_home = mysql_num_rows($news_home); $query_events_home = "SELECT * FROM events WHERE active = 1 AND home = 1 ORDER BY `order` ASC, id_events DESC LIMIT 1"; $events_home = mysql_query($query_events_home, $conn) or die(mysql_error()); $row_events_home = mysql_fetch_assoc($events_home); $totalRows_events_home = mysql_num_rows($events_home); $query_text = "SELECT * FROM text WHERE id_text = 2"; $text = mysql_query($query_text, $conn) or die(mysql_error()); $row_text = mysql_fetch_assoc($text); $totalRows_text = mysql_num_rows($text); $query_video = "SELECT * FROM galvideo WHERE active = 1 ORDER BY `order` ASC, id_galvideo DESC LIMIT 5"; $video = mysql_query($query_video, $conn) or die(mysql_error()); $row_video = mysql_fetch_assoc($video); $totalRows_video = mysql_num_rows($video); $query_contest_cat = "SELECT * FROM contest_category WHERE active = 1 ORDER BY `order` ASC, id_contest_category DESC LIMIT 1"; $contest_cat = mysql_query($query_contest_cat, $conn) or die(mysql_error()); $row_contest_cat = mysql_fetch_assoc($contest_cat); $totalRows_contest_cat = mysql_num_rows($contest_cat); $query_contest = "SELECT * FROM contest WHERE active = 1 AND id_contest_category = ".$row_contest_cat['id_contest_category']." ORDER BY `order` ASC, id_contest DESC LIMIT 1"; $contest = mysql_query($query_contest, $conn) or die(mysql_error()); $row_contest = mysql_fetch_assoc($contest); $totalRows_contest = mysql_num_rows($contest); $_page = "home"; #start output include('include/meta.php'); ?>
include('include/header.php');?>