I would like to pull from 2 different databases at the same time so that I
can have the relating information displayed together.
This is what I have so far.........any suggestions?
$sqlquery = mysql_query("SELECT * FROM log, logtime WHERE log.ID=logtime.ID
order by log.logtime desc;");
$sqlquery1 = mysql_query("SELECT * FROM logtime, log WHERE logtime.ID=log.ID
order by logtime.logtimein desc;");
while ($query = mysql_fetch_array($sqlquery)) {
$CCSD = $query["logccsd"];
$logtime = $query["logtime"];
$logid = $query["ID"];
print ("$CCSD<BR>$logtime<BR>$logid<BR><BR>");
while ($query1 = mysql_fetch_array($sqlquery1)) {
$logtimein = $query1["logtimein"];
$logccsd = $query1["logccsd"];
$logid1 = $query1["ID"];
print ("$logccsd<BR>$logtimein<BR>$logid1<BR><BR>");
// orginal time strings
$logtimeun = "$logtime";
$logtimeinun = "$logtimein";
// print ("$logtimeinun <br>$logtimeun<BR>");
// convert to unix timestamps
$logtimeunfo = strtotime($logtimeun);
$logtimeinunfo = strtotime($logtimeinun);
// perform subtraction to get the difference (in seconds) between times
$totaltimeseconds = ($logtimeinunfo-$logtimeunfo);
//echo out the difference
// printf ("%d seconds <BR>",$totaltimeseconds);
$totaltimedays = round($totaltimeseconds /60 / 60 /24,0);
$totaltimehours = date('H', mktime(0,0,$totaltimeseconds));
$totaltimeminutes = date("i", mktime(0,0,$totaltimeseconds));
//$totaltimehms= date("H:i", mktime(0,0,$totaltimeseconds));
$totaltime = ("$totaltimedays D $totaltimehours H $totaltimeminutes M");
print ("$logccsd was down for $totaltime<BR>");
}
}
This is what it displays
TM05
2002-04-22 12:29:08
738
TM06
2002-04-26 12:09:36
718
TM06 was down for 4 D 23 H 40 M
TM05
2002-04-22 19:05:30
738
TM05 was down for 0 D 06 H 36 M
TM06
2002-04-19 12:09:30
718
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
