NOW()", GetSQLValueString($colname_datat, "text")); $query_limit_datat = sprintf("%s LIMIT %d, %d", $query_datat, $startRow_datat, $maxRows_datat); $datat = mysql_query($query_limit_datat, $localhost) or die(mysql_error()); $row_datat = mysql_fetch_assoc($datat); if (isset($_GET['totalRows_datat'])) { $totalRows_datat = $_GET['totalRows_datat']; } else { $all_datat = mysql_query($query_datat); $totalRows_datat = mysql_num_rows($all_datat); } $totalPages_datat = ceil($totalRows_datat/$maxRows_datat)-1; mysql_select_db($database_localhost, $localhost); $query_dgroup = "SELECT DATUM FROM matches WHERE DATUM >='$data' GROUP BY datum ORDER BY DATUM ASC "; $dgroup = mysql_query($query_dgroup, $localhost) or die(mysql_error()); $row_dgroup = mysql_fetch_assoc($dgroup); $totalRows_dgroup = mysql_num_rows($dgroup); mysql_select_db($database_localhost, $localhost); $query_liga = "SELECT liga FROM matches WHERE datum >='$data'AND VREME>='$today' GROUP BY liga"; $liga = mysql_query($query_liga, $localhost) or die(mysql_error()); $row_liga = mysql_fetch_assoc($liga); $totalRows_liga = mysql_num_rows($liga); mysql_select_db($database_localhost, $localhost); $query_sporti = "SELECT matches.vrsta FROM matches WHERE datum >='$data' AND VREME>'$today' GROUP BY vrsta"; $sporti = mysql_query($query_sporti, $localhost) or die(mysql_error()); $row_sporti = mysql_fetch_assoc($sporti); $totalRows_sporti = mysql_num_rows($sporti); mysql_select_db($database_localhost, $localhost); $query_shpallje = "SELECT * FROM shpallje WHERE active = 1 ORDER BY shid DESC"; $shpallje = mysql_query($query_shpallje, $localhost) or die(mysql_error()); $row_shpallje = mysql_fetch_assoc($shpallje); $totalRows_shpallje = mysql_num_rows($shpallje); mysql_select_db($database_localhost, $localhost); $query_bilteni = "SELECT * FROM bilteni ORDER BY id DESC"; $bilteni = mysql_query($query_bilteni, $localhost) or die(mysql_error()); $row_bilteni = mysql_fetch_assoc($bilteni); $totalRows_bilteni = mysql_num_rows($bilteni); mysql_select_db($database_localhost, $localhost); $query_shtesat = "SELECT * FROM shtesa ORDER BY id DESC"; $shtesat = mysql_query($query_shtesat, $localhost) or die(mysql_error()); $row_shtesat = mysql_fetch_assoc($shtesat); $totalRows_shtesat = mysql_num_rows($shtesat); mysql_select_db($database_localhost, $localhost); $query_sot = "SELECT DATUM FROM matches WHERE DATUM ='$data' GROUP BY datum ORDER BY DATUM ASC "; $sot = mysql_query($query_sot, $localhost) or die(mysql_error()); $row_sot = mysql_fetch_assoc($sot); $totalRows_sot = mysql_num_rows($sot); // Initialize the Alternate Color counter $ac_sw1 = 0; ?>
|
||||
|
TË GJITHA LOJRAT
SIPAS LIGES
Vizitorėt
|
REKLAMA
|
|||
Numri i Vizitorėve: |
||||
|---|---|---|---|---|
Copyright @ 2007 ARENA SPORT-BASTORE SPORTIVE |
||||