Help to make specific rows in other color in export to excel

Hi!
Hope someone can help me how to make specific rows other color the “new posts” ( 30 days back to present day in othercolor then the rest in file )

here is the script:


<?php include('config.php'); include('opendb.php');   $selected_radio = @$_POST['formradio1'] ; switch ($selected_radio) { case 1: //$sql="SELECT * FROM foretag"; $sql="SELECT CONCAT(foretagsnamn) Företagsnamn, CONCAT(adress) Adress, CONCAT(postnr) Postnr, CONCAT(ort) Ort, CONCAT(telefon) Telefon, CONCAT(fornamn,' ',efternamn) Namn, CONCAT(email) Email, CONCAT(befattning) Befattning, CONCAT(orgnr) OrgNr, CONCAT(huvudinriktning)Huvudinriktning, CONCAT(huvudbransch) Huvudbransch, CONCAT(esn) ESN, CONCAT(branschkod) Branschkod, CONCAT(anstallda) Anställda, CONCAT(anstallda_text) AnställdaIntervall, CONCAT(omsattning_text) OmsättningIntervall, CONCAT(omsattning) Omsättning, CONCAT(kommun) Kommun, CONCAT(lan) Län, CONCAT(adressid) AdressID, CONCAT(land) Land, CONCAT(datum) Datum FROM foretag ORDER BY datum DESC";  //execute query $result = @mysql_query($sql)    or die("Couldn't execute query:<br>" . mysql_error(). "<br>" . mysql_errno());  //if this parameter is included ($w=1), file returned will be in word format ('.doc') //if parameter is not included, file returned will be in excel format ('.xls') if (isset($w) && ($w==1)) {    $file_type = "msword";    $file_ending = "doc"; }else {    $file_type = "vnd.ms-excel";    $file_ending = "xls"; } //header info for browser: determines file type ('.doc' or '.xls') header("Content-Type: application/$file_type"); header("Content-Disposition: attachment; filename=test.$file_ending"); header("Pragma: no-cache"); header("Expires: 0");  /*   Start of Formatting for Word or Excel   */  if (isset($w) && ($w==1)) //check for $w again {    //define separator (defines columns in excel & tabs in word)    $sep = "\
"; //new line character     while($row = mysql_fetch_row($result))    {       //set_time_limit(60); // HaRa       $schema_insert = "";       for($j=0; $j<mysql_num_fields($result);$j++)       {       //define field names       $field_name = mysql_field_name($result,$j);       //will show name of fields       $schema_insert .= "$field_name:\	";          if(!isset($row[$j])) {             $schema_insert .= "NULL".$sep;             }          elseif ($row[$j] != "") {             $schema_insert .= "$row[$j]".$sep;             }          else {             $schema_insert .= "".$sep;             }       }       $schema_insert = str_replace($sep."$", "", $schema_insert);       $schema_insert .= "\	";       print(trim($schema_insert));       //end of each mysql row       //creates line to separate data from each MySQL table row       print "\
----------------------------------------------------\
";    } }else{    //define separator (defines columns in excel & tabs in word)    $sep = "\	"; //tabbed character     //start of printing column names as names of MySQL fields    for ($i = 0; $i < mysql_num_fields($result); $i++)    {       echo mysql_field_name($result,$i) . "\	";    }    print("\
");    //end of printing column names     //start while loop to get data    while($row = mysql_fetch_row($result))    {       //set_time_limit(60);       $schema_insert = "";       for($j=0; $j<mysql_num_fields($result);$j++)       {          if(!isset($row[$j]))             $schema_insert .= "NULL".$sep;          elseif ($row[$j] != "")             $schema_insert .= "$row[$j]".$sep;          else             $schema_insert .= "".$sep;       }       $schema_insert = str_replace($sep."$", "", $schema_insert);        //this corrects output in excel when table fields contain \
 or \\r       //these two characters are now replaced with a space       $schema_insert = preg_replace("/\\r\
|\
\\r|\
|\\r/", " ", $schema_insert);       $schema_insert .= "\	";       print(trim($schema_insert));       print "\
";    } }     break; case 2:     include("Choice_2.php");     break; case 3:     include("Choice_3.php");     break; case 4:     include("Choice_4.php");     break; case 5:     include("Choice_5.php");     break; case 6:     include("Choice_6.php");     break; }  ?> 

hi!
need help how to make the rows that are “new” ( 30 days back to present day a other color than the “old” rows )

here is my script:


<?php  
include('config.php'); 
include('opendb.php'); 
$selected_radio = @$_POST['formradio1'] ; 
switch ($selected_radio) { 
 case 1: 
 //$sql="SELECT * FROM foretag"; 
 $sql="SELECT CONCAT(foretagsnamn) Företagsnamn, CONCAT(adress) Adress, CONCAT(postnr) Postnr, CONCAT(ort) Ort, CONCAT(telefon) Telefon, CONCAT(fornamn,' ',efternamn) Namn, CONCAT(email) Email, CONCAT(befattning) Befattning, CONCAT(orgnr) OrgNr, CONCAT(huvudinriktning)Huvudinriktning, CONCAT(huvudbransch) Huvudbransch, CONCAT(esn) ESN, CONCAT(branschkod) Branschkod, CONCAT(anstallda) Anställda, CONCAT(anstallda_text) AnställdaIntervall, CONCAT(omsattning_text) OmsättningIntervall, CONCAT(omsattning) Omsättning, CONCAT(kommun) Kommun, CONCAT(lan) Län, CONCAT(adressid) AdressID, CONCAT(land) Land, CONCAT(datum) Datum FROM foretag ORDER BY datum DESC"; 

//execute query 
 $result = @mysql_query($sql)    or die("Couldn't execute query:<br>" . mysql_error(). "<br>" . mysql_errno()); 

  //if this parameter is included ($w=1), file returned will be in word format ('.doc') 
 //if parameter is not included, file returned will be in excel format ('.xls') 
 if (isset($w) && ($w==1)) {
    $file_type = "msword"; 
 $file_ending = "doc"; }else { 
 $file_type = "vnd.ms-excel"; 
 $file_ending = "xls"; } //header info for browser: determines file type ('.doc' or '.xls') 
 header("Content-Type: application/$file_type"); 
 header("Content-Disposition: attachment; 
 filename=test.$file_ending"); 
 header("Pragma: no-cache"); 
 header("Expires: 0"); 
  /*   Start of Formatting for Word or Excel   */ 
  if (isset($w) && ($w==1)) //check for $w again { 
    //define separator (defines columns in excel & tabs in word) 
    $sep = "\
"; //new line character 
     while($row = mysql_fetch_row($result))    {  
      //set_time_limit(60); 
$schema_insert = ""; 
       for($j=0; $j<mysql_num_fields($result);$j++)       { 
       //define field names 
       $field_name = mysql_field_name($result,$j); 
       //will show name of fields 
       $schema_insert .= "$field_name:\	"; 
          if(!isset($row[$j])) { 
             $schema_insert .= "NULL".$sep; 
             } 
          elseif ($row[$j] != "") { 
             $schema_insert .= "$row[$j]".$sep; 
             } 
          else { 
             $schema_insert .= "".$sep; 
             }  
      }  
      $schema_insert = str_replace($sep."$", "", $schema_insert); 
       $schema_insert .= "\	"; 
       print(trim($schema_insert)); 
       //end of each mysql row 
       //creates line to separate data from each MySQL table row 
       print "\
----------------------------------------------------\
"; 
    } }else{  
   //define separator (defines columns in excel & tabs in word) 
    $sep = "\	"; //tabbed character 
     //start of printing column names as names of MySQL fields 
    for ($i = 0; $i < mysql_num_fields($result); $i++)    { 
       echo mysql_field_name($result,$i) . "\	";    } 
    print("\
");    //end of printing column names  
    //start while loop to get data 
    while($row = mysql_fetch_row($result))    { 
       //set_time_limit(60); 
       $schema_insert = ""; 
       for($j=0; $j<mysql_num_fields($result);$j++)       { 
          if(!isset($row[$j])) 
             $schema_insert .= "NULL".$sep; 
          elseif ($row[$j] != "") 
             $schema_insert .= "$row[$j]".$sep; 
          else  
            $schema_insert .= "".$sep; 
       }  
      $schema_insert = str_replace($sep."$", "", $schema_insert); 
        //this corrects output in excel when table fields contain \
 or \\r  
      //these two characters are now replaced with a space 
       $schema_insert = preg_replace("/\\r\
|\
\\r|\
|\\r/", " ", $schema_insert); 
       $schema_insert .= "\	"; 
       print(trim($schema_insert)); 
       print "\
";    } }  
    break; case 2: 
     include("Choice_2.php");  
    break; 
 case 3:  
    include("Choice_3.php"); 
     break; 
 case 4: 
     include("Choice_4.php"); 
     break; 
 case 5: 
     include("Choice_5.php"); 
     break; 
 case 6: 
     include("Choice_6.php"); 
     break; 
 }  
 ?>