include "db.php";
include "common.php";
?>
Лёгкий поиск по базе вопросов
if (@$_GET['sstr']) {
$sstr=stripslashes($_GET['sstr']);
$g=addslashes($sstr);
$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 MATCH (Question,Answer,PassCriteria,Comments) AGAINST ('$g' IN BOOLEAN MODE)
ORDER BY MATCH (Question,Answer,PassCriteria,Comments) AGAINST ('$g' IN BOOLEAN MODE) DESC
LIMIT $limit";
print_questions_sql($sql,true);
} else {
?>
}?>
Поиск производится по копии базы от