1,'Answer'=>1,'PassCriteria'=>1);
$and=@$_GET['all_words'] or $and=false;
?>
Подстрочный поиск по базе вопросов
$v) {
$fields[]="IFNULL($v,'')";
}
$fields=implode(',',$fields);
foreach ($swords as $v) {
$where_array[]="CONCAT($fields) LIKE '%".addslashes($v)."%'";
}
$where=implode(($and?' AND ':' OR '),$where_array);
$sql="SELECT t.FileName as tFileName, t1.FileName as t1FileName, q.*, t.Id as tid,t1.id as ttid, t.Title as ttitle,t1.title as tttitle FROM Questions q LEFT JOIN Tournaments t
ON (q.ParentId=t.Id) LEFT JOIN Tournaments t1 ON (t.ParentId=t1.Id)
WHERE $where LIMIT 500";
print_questions_sql($sql,true);
} else {
?>