include "includes/elements/search_head.php";
if (chop($search)!="" || chop($search)!=0) {
connect_to_db($db_host,$db_user,$db_pwd,$db_name);
if ($newest != "all") { $sel_max = $newest; }
switch ($searchtype) {
case "regular":
$query = "SELECT ProgramID, ProgramTitle, Series from programs
where ProgramTitle like '%$searchtext%'
OR Subtitle like '%$searchtext%'
OR Series like '%$searchtext%'
OR Speaker like '%$searchtext%'
OR Keywords like '%$searchtext%'
order by ProgramID DESC";
$result = db_query($query);
$nresult = db_num_rows($result);
break;
case "author":
$query = "SELECT ProgramID, ProgramTitle, Series from programs
where Author like '%$searchtext%'
OR AuthorEmail like '%$searchtext%'
order by ProgramID DESC";
$result = db_query($query);
$nresult = db_num_rows($result);
break;
case "uploader":
$query = "SELECT ProgramID, ProgramTitle, Series from programs
where Contact like '%$searchtext%'
OR ContactEmail like '%$searchtext%'
order by ProgramID DESC";
$result = db_query($query);
$nresult = db_num_rows($result);
break;
case "filename":
$query = "SELECT DISTINCT(programs.ProgramID), programs.ProgramTitle, programs.Series, files.ProgramID from files, programs
where files.Filename like '%$searchtext%'
AND files.ProgramID = programs.ProgramID
order by programs.ProgramID DESC";
$result = db_query($query);
$nresult = db_num_rows($result);
break;
default:
$nresult = 0;
break;
}
echo "You searched for: \" $searchtext\"
";
$i = 0;
if ($nresult==0) {
echo "
| Search Results |
\n";
echo "| Sorry. No Records Were Found That Matched Your Criteria. |
\n";
}
elseif ($nresult!=0) {
echo "| Search Results: $nresult Record(s) Found |
\n";
while ($i!=$nresult){
$programid = db_result($result,$i,"ProgramID");
$programtitle = stripslashes(db_result($result,$i,"ProgramTitle"));
$series = stripslashes(db_result($result,$i,"Series"));
$langsearch = db_result($result,$i,"Language");
echo "| ";
if ($series!="") { echo "$series:\n"; }
echo " $programtitle |
\n";
$i++;
}
}
echo "
";
}
include "includes/elements/search_foot.php";
?>