";
if($_GET){
$smj = $_GET['smj'];
$PoS = $_GET['PoS'];
$nob = $_GET['nob'];
$sve = $_GET['sve'];
$eng = $_GET['eng'];
$dq = '"';
if ($smj==""&&$PoS==""&&$nob==""&&$sve==""&&$eng=="") $emptyRequest = 1; else $emptyRequest = 0;
$connect = mysql_connect("localhost","root","root");
if($connect){
$toDB = mysql_select_db("smjDATA",$connect);
if($toDB){
mysql_set_charset('utf8',$connect);
$querySMJ = "smj LIKE '" . $smj . "%'";
$querySMJPoS = "smj_pos LIKE '" . $PoS . "%'";
$queryPoS = "pos LIKE '" . $PoS . "%'";
$queryNOB = "nob1 LIKE '" . $nob . "%'";
$querySVE = "sve1 LIKE '" . $sve . "%'";
$queryENG = "eng1 LIKE '" . $eng . "%'";
//the actual query here:
$query = "SELECT * FROM table_SIMPLE WHERE " . $querySMJ . " AND " . $queryPoS . " AND " . $queryNOB . " AND " . $querySVE . " AND " . $queryENG
;
$results = mysql_query($query);
$qtyHits = mysql_num_rows($results);
// $clickHint = "";
$clickHint = "";
if( $qtyHits == 0 ) echo $resultHeader."".$doubleDIV."
Sorry, no hits.
" ;
else {
if ($emptyRequest==1) echo $resultHeader."".$doubleDIV."".$doubleDIV."" ;
}
}
echo "
";
}
else {
die("
Failed to connect to database! " . mysql_error());
}
}
else {
die("
Failed to connect to mysql! " . mysql_error());
}
}
else echo $resultHeader."".$doubleDIV;
?>