if($y == ""){
$new_time = date("Y");
$y = $new_time;
}
switch ($y) {
case 2016:
$front16 = "";
$back16 = "";
break;
case 2015:
$front15 = "";
$back15 = "";
break;
case 2014:
$front14 = "";
$back14 = "";
break;
case 2013:
$front13 = "";
$back13 = "";
break;
case 2012:
$front12 = "";
$back12 = "";
break;
case 2011:
$front11 = "";
$back11 = "";
break;
case 2010:
$front10 = "";
$back10 = "";
break;
case 2009:
$front09 = "";
$back09 = "";
break;
case 2008:
$front08 = "";
$back08 = "";
break;
default:
}
?>
The IFTA News
The IFTA News
echo "$y"; ?> |
|
|
|
////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////
$db_name = "comhold";
$table_name = "news";
//databases that store this temporary stuff.
include("c:/thisconnector/thisconnector.php");
$db = mysql_select_db($db_name, $connection)
or die("Couldn't select database.");
////////////////////////////////////////////////////////////////////////
$sql = "SELECT * FROM $table_name
WHERE year = '$y'
";
$result = mysql_query($sql,$connection)
or die("Couldn't execute query 2.1");
while ($row = mysql_fetch_array($result)){
$url = $row["url"];
$text = $row["text"];
$xdate = $row["xdate"];
$xyear = $row["year"];
echo "$text |
Click here
";
}
$gyear = $year;
?>
|