@greeting[]
Поиск

@submenu[]

@infa[]
<FORM TARGET=_top ACTION=/search.html METHOD=GET>
        <input type=text name=search size=50 MAXLENGTH=100 value="" style="font-size: 9pt">&nbsp;
        <input type=submit value="найти" style="font-size: 8pt">
</FORM>

^if(def $form:search){
        ^connect[$connect_string]{
                $cat[^table::sql{select id, DATE_FORMAT(date, '%d.%m.%Y') as date, head, text from news where (head like '%$form:search%' or text like '%$form:search%')}]
                ^if(def $cat){
                $counter[^eval($counter+^cat.count[])]
                        ^cat.menu{
                                <a id=nolnkb href="/news/index.html?id=${cat.id}">$cat.date : Новости : ^untaint{$cat.head}</a><br>
                        }
                }
                $cat[^table::sql{select text.id, text.name, text.text, DATE_FORMAT(calendar.date, '%d.%m.%Y') as date, calendar.id as rezid, calendar.name as racename, text.race_id from text, calendar where (text.name like '%$form:search%' or text.text like '%$form:search%') and text.race_id=calendar.id}]
                ^if(def $cat){
                $counter[^eval($counter+^cat.count[])]
                        ^cat.menu{
                                <a id=nolnkb href="/sport/text.html?id=${cat.id}">$cat.date : $cat.racename : ^untaint{$cat.name}</a><br>
                        }
                }
                <br>Всего запросу "<b>$form:search</b>" найдено записей: $counter
        }
}