";
echo " ---- SCIENCE NEWS ---- ";
$result = mysql_query("SELECT * FROM consolidated_news WHERE genre = 'Science' AND main LIKE '$search_value%' OR genre = 'Science' AND searchable LIKE '$search_value%' ORDER by unix_time DESC",$db);
if ($myrow = mysql_fetch_array($result)) {
do {
echo $myrow["time"];
echo " (";
echo $myrow['source'];
echo ")";
echo " ";
printf("%s \n", $myrow["id"], $myrow["header"]);
echo " ";
} while ($myrow = mysql_fetch_array($result));
} else {
echo " No Science News for keyword selected. ";
}
echo " | ";
echo " ---- BUSINESS NEWS ---- ";
$result = mysql_query("SELECT * FROM consolidated_news WHERE genre = 'Business' AND main LIKE '$search_value%' OR genre = 'Business' AND searchable LIKE '$search_value%' ORDER by unix_time DESC",$db);
if ($myrow = mysql_fetch_array($result)) {
do {
echo $myrow["time"];
echo " (";
echo $myrow['source'];
echo ")";
echo " ";
printf("%s \n", $myrow["id"], $myrow["header"]);
echo " ";
} while ($myrow = mysql_fetch_array($result));
} else {
echo " No Business News for keyword selected.";
}
echo " | ";
echo " ---- PRESS RELEASES ---- ";
$result = mysql_query("SELECT * FROM consolidated_news WHERE genre = 'PR' AND main LIKE '$search_value%' ORDER by unix_time DESC",$db);
if ($myrow = mysql_fetch_array($result)) {
do {
echo $myrow["time"];
echo " (";
echo $myrow['source'];
echo ")";
echo " ";
printf("%s \n", $myrow["id"], $myrow["header"]);
echo " ";
} while ($myrow = mysql_fetch_array($result));
} else {
echo " No Press Releases for keyword selected.";
}
echo " |