connect_error) { die("Connection to mysql database failed: " . $conn->connect_error); } $result = $conn->query( "SELECT" . " `build_slaves`.`name`," . "`build_slaves`.`operator`," . "`package_sources`.`pkgbase`," . "`build_slaves`.`last_connection`" . " FROM `build_slaves`" . " LEFT JOIN `build_assignments` ON" . " `build_slaves`.`currently_building`=`build_assignments`.`id`" . " LEFT JOIN `package_sources` ON" . " `build_assignments`.`package_source`=`package_sources`.`id`" . " ORDER BY `build_slaves`.`last_connection`" ); print "
\n"; if ($result->num_rows > 0) { print "
name
operator
currently building
last connection
\n"; while ($row = $result -> fetch_assoc()) { foreach ($row as $key => $value) { if ($value=="") { $row[$key]=" "; } } print "
"; print "
".$row["name"]."
"; print "
".$row["operator"]."
"; print "
".$row["pkgbase"]."
"; print "
".$row["last_connection"]."
"; print "
\n"; } } print "
\n"; ?>