";
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("dasr", $con)
or die ("could not select database!");
$result = mysql_query("
SELECT bedfile_id, name,upload_date,lastname
FROM bedfile NATURAL JOIN experiment NATURAL JOIN researcher
WHERE name LIKE $dquery
UNION
SELECT bedfile_id, name,upload_date,lastname
FROM bedfile NATURAL JOIN experiment NATURAL JOIN researcher
WHERE lastname LIKE $nquery
UNION
SELECT bedfile_id, name,upload_date,lastname
FROM bedfile NATURAL JOIN experiment NATURAL JOIN researcher
WHERE firstname LIKE $nquery
ORDER BY name;");
$output = $row = mysql_fetch_array($result);
if (!$output)
echo "Result: None found ";
echo "