" . $crq . " - Equipment";
}
// Display an error message and exit
else {
exit("Error! No CRQ specified");
}
$db_handle = new SQLite3($filename);
$results = $db_handle->query($query_string);
echo "\n\n";
// Find all equipment that isn't listed in the device table
$query_string = "SELECT Device FROM Equipment WHERE NOT EXISTS (SELECT * FROM Device WHERE Equipment.Device = Device.Description) AND CRQ = \"$crq\"";
$results = $db_handle->query($query_string);
echo "Equipment not found in Device table
";
while ($row = $results->fetchArray()) {
echo $row['Device'] . "
\n";
}
?>