News

Multichannel News Issue Archives 2000-Present

12/13/2012 6:56 AM Eastern

echo 'Browse by Issue Year';
echo "


";
echo '
2014 2013 2012 | 2011 | 2010 |
2009
| 2008 | 2007 | 2006 | 2005 | 2004 | 2003 | 2002 | 2001 | 2000

';

$dateval = $_GET['datevalue'];

if ($_GET['datevalue'])
{

$query=mysql_query("select DISTINCT(issue),archive_issueno.date from archive_issueno
where SUBSTR(date,1,4)= $dateval limit 0,50");

}else {
$query=mysql_query("select DISTINCT(issue),archive_issueno.date from archive_issueno
where SUBSTR(date,1,4)= '2014' limit 0,50");
}

echo "

";
echo "
";

echo "

";

echo "

";

echo "

";

echo "

";

echo "

";
echo "

";
echo "1st Quarter";

while($result=mysql_fetch_object($query))
{
// print_r($result);

// echo
$result->date;
// echo
//$day = substr($result->date, -2); // returns "f"
// $month = substr($result->date, -4, 2); // returns "d"
// echo
$monthNum = $month;
// echo
//$monthName = date("F", mktime(0, 0, 0, $monthNum, 10));
// $monthName; //output: May
//http://multichannel.com/coverstory/20120402

// print_r($result);
$result->date;
$day = substr($result->date, -2); // returns "f"
// echo echo
$year= substr($result->date, 0,-4);
$month = substr($result->date, -4, 2); // returns "d"
$monthNum = $month;
$monthName = date("F", mktime(0, 0, 0, $monthNum, 10));
$monthName; //output: May

echo "

";
echo "
";

if ($monthName=="January" || $monthName=="February" || $monthName=="March")
{

$pos = substr($result->date,0,4);

if($result->issue=="1" && $pos=="2013")
{

$cont = substr($result->date,0,4);
$cont1 = substr($result->date,-2);
$cont2 = substr($result->date,4,2);
$content = $cont."-".$cont2."-".$cont1;

echo "

";
echo "

";
echo "

";
echo "

";
echo "

";
echo "

";
echo "

";
echo "

";
echo "

";
echo "

";
echo "

";
echo "

";

echo "

";

echo "

";
echo "

";
echo "

";
echo "

";
echo "

";
echo "

";
echo "

";
echo "

";

echo "

";
echo "

";
echo "

";

echo "

";
echo "

";
echo "

";

echo "

";
echo "

";
echo "

";

echo "

";
echo "

";
echo "

";

echo "

";
echo "

";
echo "

";

echo "

";
echo "

";
echo "

";

}
else if ($year=="2014")
{

$cont = substr($result->date,0,4);
$cont1 = substr($result->date,-2);
$cont2 = substr($result->date,4,2);
$content = $cont."-".$cont2."-".$cont1;
echo "

";
}
else{

echo "

";
}

}
echo "

";
echo "

";
echo "issue&field_coverdatae_value=$content>"."Issue"." ".$result->issue." ".$monthName." ".$day."";
echo "
";
echo ""."Issue 2 January 14"."";
echo "
";
echo ""."Issue 3 January 21"."";
echo "
";
echo ""."Issue 4 January 28"."";
echo "
";
echo ""."Issue 5 February 04 "."";
echo "
";
echo ""."Issue 6 February 11 "."";
echo "
";
echo ""."Issue 7 February 18 "."";
echo "
";
echo ""."Issue 8 February 25"."";
echo "
";
echo ""."Issue 9 March 4"."";
echo "
";
echo ""."Issue 10 March 11"."";
echo "
";
echo ""."Issue 11 March 18"."";
echo "
";
echo ""."Issue 12 March 25"."";
echo "
";
echo ""."Issue 13 Apr 1"."";
echo "
";
echo "issue."&field_coverdatae_value=".$content.">"."Issue"." ".$result->issue." ".$monthName." ".$day."";
echo "
";
echo "date>"."Issue"." ".$result->issue." ".$monthName." ".$day."";
echo "

";
}

echo "

";
echo "2nd Quarter";

if ($_GET['datevalue'])
{
$query=mysql_query("select DISTINCT(issue),archive_issueno.date from archive_issueno
where SUBSTR(date,1,4)= $dateval order by issue asc limit 0,50");
}
else {
$query=mysql_query("select DISTINCT(issue),archive_issueno.date from archive_issueno
where SUBSTR(date,1,4)= '2014' order by issue asc limit 0,50");
}

while($result=mysql_fetch_object($query))
{
// print_r($result);
$result->date;
$day = substr($result->date, -2); // returns "f"
// echo echo
$year= substr($result->date, 0,-4);
$month = substr($result->date, -4, 2); // returns "d"
$monthNum = $month;
$monthName = date("F", mktime(0, 0, 0, $monthNum, 10));
$monthName; //output: May

echo "

";
echo "
";

if ($monthName=="April" || $monthName=="May" || $monthName=="June")
{
if ($year=="2013")
{
echo "

";
}else {
echo "

";

}
}
echo "

";
echo "

";
echo "issue."&field_coverdatae_value=".$result->date.">"."Issue"." ".$result->issue." ".$monthName." ".$day."";

echo "

";
echo "date>"."Issue"." ".$result->issue." ".$monthName." ".$day."";
echo "

";
}

echo "

";
echo "3rd Quarter";

if ($_GET['datevalue'])
{
$query=mysql_query("select DISTINCT(issue),archive_issueno.date from archive_issueno
where SUBSTR(date,1,4)= $dateval order by issue asc limit 0,50");
}
else {
$query=mysql_query("select DISTINCT(issue),archive_issueno.date from archive_issueno
where SUBSTR(date,1,4)= '2014' order by issue asc limit 0,50");
}

while($result=mysql_fetch_object($query))
{
// print_r($result);
$result->date;
$day = substr($result->date, -2); // returns "f"
// echo echo
$year= substr($result->date, 0,-4);
$month = substr($result->date, -4, 2); // returns "d"
$monthNum = $month;
$monthName = date("F", mktime(0, 0, 0, $monthNum, 10));
$monthName; //output: May
echo "

";
echo "
";

if ($monthName=="July" || $monthName=="August" || $monthName=="September")
{
if ($year=="2013")
{
echo "

";
}else {
echo "

";

}
}
echo "

";
echo "

";
echo "issue."&field_coverdatae_value=".$result->date.">"."Issue"." ".$result->issue." ".$monthName." ".$day."";

echo "

";
echo "date>"."Issue"." ".$result->issue." ".$monthName." ".$day."";
echo "

";
}

echo "

";
echo "4th Quarter";
if ($_GET['datevalue'])
{

$query=mysql_query("select DISTINCT(issue),archive_issueno.date from archive_issueno
where SUBSTR(date,1,4)= $dateval limit 0,50");

}else {
$query=mysql_query("select DISTINCT(issue),archive_issueno.date from archive_issueno
where SUBSTR(date,1,4)= '2014' limit 0,50");
}

while($result=mysql_fetch_object($query))
{
//print_r($result);

$result->date;
$day = substr($result->date, -2); // returns "f"
$month = substr($result->date, -4, 2); // returns "d"
$monthNum = $month;
$monthName = date("F", mktime(0, 0, 0, $monthNum, 10));
$monthName; //output: May

echo "

";
echo "
";
if ($monthName=="October" || $monthName=="November"|| $monthName=="December") {

$pos = substr($result->date,0,4);

if($result->issue=="1" && $pos=="2013" || $result->issue=="48" && $pos=="2012" || $result->issue=="49" && $pos=="2012" || $result->issue=="38" && $pos=="2013"|| $result->issue=="39" && $pos=="2013"|| $result->issue=="40" && $pos=="2013" ||$result->issue=="41" && $pos=="2013" ||$result->issue=="42" && $pos=="2013"||$result->issue=="43" && $pos=="2013" || $result->issue=="44" && $pos=="2013" || $result->issue=="45" && $pos=="2013" || $result->issue=="46" && $pos=="2013" || $result->issue=="47" && $pos=="2013" || $result->issue=="48" && $pos=="2013")
{

$cont = substr($result->date,0,4);
$cont1 = substr($result->date,-2);
$cont2 = substr($result->date,4,2);
$content = $cont."-".$cont2."-".$cont1;

echo "

";

}else{

echo "

";
}

}
echo "

";
echo "

";
echo "issue&field_coverdatae_value=$content>"."Issue"." ".$result->issue." ".$monthName." ".$day."";
echo "
";
echo "date>"."Issue"." ".$result->issue." ".$monthName." ".$day."";
echo "

";
}

echo "

";

?>

September