Archives

Author:
Publish date:
Updated on

$query=mysql_query("SELECT DISTINCT fi.field_issueno_value,fc.field_coverdate_value from content_field_issueno fi,content_type_article fc where fi.nid=fc.nid and fi.field_issueno_value is not NULL order by fc.field_coverdate_value DESC LIMIT 0,8");

echo "

MCN-2012

";
$num =0;
while($display=mysql_fetch_object($query))
{

//echo $num;

if($num==0 || $display->field_issueno_value ==45)
{
}else{
$nid=$display->nid;
$field_coverdate_value=$display->field_coverdate_value;
$field_issueno_value=$display->field_issueno_value;

$newDate = date("M,d,Y", strtotime($display->field_coverdate_value));
//$display->field_coverdate_value=date("F,d,Y");

echo "

field_issueno_value&field_coverdate_value=$display->field_coverdate_value>Issue $display->field_issueno_value :  $newDate

";

}
$num++;
}

?>

Related