rashmi_k28
03-31-2008, 11:11 PM
Suppose I have 3 dates and rows fetched from table should be displayed in 3 separate table for each date.
But table displaying now doesnot show the rows for that particular date in table.
Table is divided into 3 but first table shows the rows which contains date as on '2008-03-18' and second table shows 18th and 19th dates rows and third table contains all the rows fetched from the table.
How to display rows based on date in particular table
$start_date='2008-03-18';
$end_date='2008-03-20';
$res_date=mysql_query("select distinct(date(timestamp)) from `table` where date(timestamp)>= '".$start_date."' and date(timestamp) <= '".$end_date."'");
while($res2=mysql_fetch_array($res_date)){
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;
}
}
echo "<html>";
echo "<head>";
echo "<TABLE BORDER=2 CELLPADDING=4 width=\"100%\" bordercolor=\"#000000\"><TR><TH COLSPAN=2>DATE AS ON $res2[0]</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>NAME</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+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><br><br></table>";
}
echo "</body></html>";
But table displaying now doesnot show the rows for that particular date in table.
Table is divided into 3 but first table shows the rows which contains date as on '2008-03-18' and second table shows 18th and 19th dates rows and third table contains all the rows fetched from the table.
How to display rows based on date in particular table
$start_date='2008-03-18';
$end_date='2008-03-20';
$res_date=mysql_query("select distinct(date(timestamp)) from `table` where date(timestamp)>= '".$start_date."' and date(timestamp) <= '".$end_date."'");
while($res2=mysql_fetch_array($res_date)){
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;
}
}
echo "<html>";
echo "<head>";
echo "<TABLE BORDER=2 CELLPADDING=4 width=\"100%\" bordercolor=\"#000000\"><TR><TH COLSPAN=2>DATE AS ON $res2[0]</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>NAME</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+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><br><br></table>";
}
echo "</body></html>";