Each table datewise

sandy1028

I have a code and I have to display the each table separately depending on the date.

Suppose I have 3 dates,

The records of each date should be displayed in separate table. Please tell me how to do it.

$start_date       = $_REQUEST["date1"];
$end_date         = $_REQUEST["date2"];

$res_head="select distinct(date(timestamp) from `tablename` where date(timestamp) >='".$start_date."' date(timestamp) <= '".$end_date."' and status=0";
$res1=mysql_query($res_head);
while($res=mysql_fetch_array($res1)){

//Some code

 array_push($records,"$result[2]#$ip[0]#$result[2]#$previoustime#$result[1]#$d");

<TABLE BORDER=2 CELLPADDING=4 width=\"100%\" bordercolor=\"#000000\"><TR><TH COLSPAN=2>DATE AS ON $start_date</TH><th COLSPAN=6>Status(Down)</th></TR><TR><TH COLSPAN=8> STATUS OF NETWORK</TH></TR><TR><TD>SL NO</TD><TD>CLIENT NAME</TD><TD>IP ADDRESS</TD><TD> NAME</TD><TD>START TIME</TD><TD>END TIME</TD><TD>DURATION in (days:hours:minutes)</TD></TR>

sandy1028

Hi,

Anyone please help me with this. I have attached the image how the table should look like

Betard

can you not simply do something along the lines of

while ($date1 == $fetchedDate) {

build table with data fetched from related rows

$fetchedDates = next date

}

might help to know more about where the dates are coming from, are the dates pre-defined, are they date ranges, etc...

NogDog

$sql = "SELECT col1, col2,...,coln, timestamp_col <blah blah blah> ORDER BY timestamp_col";
$result = mysql_query($sql);
$dataByDate = array();
while($row = mysql_fetch_assoc($result))
{
   $dataByDate[$row['timestamp_col']][] = $row;
}
foreach($dataByDate as $date => $data)
{
   echo "<table>";
   // do first row using $data['timestamp_col'] value for date
   foreach($data as $row)
   {
      // output table row using array elements in $row.
   }
   echo "</table>";
}

sandy1028

Hi,

The code I am using now is like this:

while($result = mysql_fetch_array($row))
{

$sql_ip="select ip from `table_name` where head_node='".$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>";

......

<table>.....

In this how can I use. I am copying the values into records. Then from records I am displaying in table.

sandy1028

Hi,

Anyone please help me how to proceed.

Based on the date I have to make separate table.