Error:
"; die ("Can't connect to the db"); } if (isset($_GET[id])) { $hostid=$_GET[id]; $query = "SELECT partid.partname, saveinfo.status, saveinfo.level, saveinfo.duration, saveinfo.files, sum(saveinfo.size)/1024, partid.id FROM hostid,partid,saveinfo WHERE hostid.id = $hostid AND hostid.id = partid.hostid AND saveinfo.partid = partid.id AND saveinfo.date = '$date' GROUP BY partid.id ORDER BY partid.partname"; $result=mysql_db_query("$db", "$query"); $numrows=mysql_num_rows($result); if($numrows > 0) { PRINT ""; } $i=0; while ($r=mysql_fetch_array($result)) { $partid = $r["id"]; $partname = $r["partname"]; $status = $r["status"]; $level = $r["level"]; $duration = $r["duration"]; $files = $r["files"]; $size = $r["sum(saveinfo.size)/1024"]; ?> $partname"; } else { PRINT ""; } PRINT ""; $i++; PRINT ""; } PRINT "
PartitionStatusLevelDuration FilesSize (MB)
$partname $status $level$duration $files$size
"; } ?>