Hi,

I have to divide the table date wise and show the rows fetched from the database in datewise for a particular table
I have the code below..
Please help me how can I proceed.

I have attached the image like how the table should look like.

Code:
//$start_date='2008-03-18';
//$end_date='2008-03-20';
$start_date       = $_REQUEST["date1"];
$end_date         = $_REQUEST["date2"];

$records=array();
$res_date=mysql_query("select distinct(date(timestamp)) from `table1` where date(timestamp)>= '".$start_date."' and date(timestamp) <= '".$end_date."'");
while($res2=mysql_fetch_array($res_date)){
$res_head="select distinct(name) from `table1` where date(timestamp)='".$res2[0]."' and status=0";
$res1 = mysql_query($res_head);
while($res = mysql_fetch_array($res1)){

$sql = "SELECT status,timestamp,name FROM `table1` WHERE name='".$res[0]."' and date(timestamp)='".$res2[0]."'";
$row = mysql_query($sql);
$previousStatus = '';
$currentStatus = '';
$previoustime='';
$currentTime='';
while($result = mysql_fetch_array($row))
{

$sql_ip="select ip from `table2` where name='".$res[0]."'";
        $sql_ip1=mysql_query($sql_ip);
while($ip=mysql_fetch_array($sql_ip1)){

    $currentStatus = $result['status'];
    $currentTime = $result['timestamp'];
    $previousStatus = $previousStatus == '' ? $currentStatus : $previousStatus;
    $previoustime = $previoustime == '' ? $currentTime : $previoustime;

    if($previousStatus <> $currentStatus)
    {
        $d = strtotime($currentTime) - strtotime($previoustime);
        array_push($records,"$result[2]#$ip[0]#$result[2]#$previoustime#$result[1]#$d");

        }
    $previousStatus = $currentStatus;
}
}
}
}
header("Pragma: public");
    header("Expires: 0");
    header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
    header("Cache-Control: public");
 //   header("Content-Description: File Transfer");
header("Content-Type: application/msword");
//$header="Content-Disposition: attachment; filename=".$filename.";";
    header($header);
 //   header("Content-Transfer-Encoding: binary");
 //   header("Content-Length: ".$len);

echo "<html>";
echo "head>";



echo "<META HTTP-EQUIV=\"REFRESH\" CONTENT=\"1\">";
echo "</head>";
//header("Content-Disposition: attachment; filename=worddoc.doc");

echo "<html><head><title>REPORT</title></head><body bgcolor=\"#FFFFFF\" text=\"#000000\">";
echo "<TABLE BORDER=2 CELLPADDING=4 width=\"100%\" bordercolor=\"#000000\"><TR><TH COLSPAN=2>DATE AS ON </TH><th COLSPAN=6>Status(Down)</th></TR><TR><TH COLSPAN=8>NETWORK</TH></TR><TR><TD>SL NO</TD><TD>NAME</TD><TD>IP</TD><TD>NAME1</TD><TD>START TIME</TD><TD>END TIME</TD><TD>DURATION in (days:hours:minutes)</TD></TR>";
$x=count($records);
for($i=0;$i<count($records);$i++){
$data=split("#",$records[$i]);
 $seconds=$data[5];
$hours = floor($seconds/3600);
                        $days=floor($hours/24);
                        $hoursleft= $hours%24;
                         $timeleft = $seconds - ($hours*3600);
                  $minutes = floor($timeleft/60);
                        $seconds = $timeleft - ($minutes*60);

echo "<tr>";
//echo "<td>$i</td>";
echo "<td>".($i+1)."</td>";
echo "<td>$data[0]</td>";
echo "<td>$data[1]</td>";
echo "<td>$data[2]</td>";
echo "<td>$data[3]</td>";
echo "<td>$data[4]</td>";
echo "<td>$days:$hoursleft:$minutes</td>";
}
echo "</tr></table>";
echo "</body></html>";