(SELECT ...
FROM ...
WHERE `score` > ...
ORDER BY `score`
LIMIT 5)
UNION (SELECT ...
FROM ...
WHERE `score` < ...
ORDER BY `score` DESC
LIMIT 5)
с формы приходят данные
f1,f2,f3,d1,d2,d3,d4
f1,f2,f3 - числа
d1 - категория
d2,d3 - дата от и до
d4 - сортировка 'DESC', 'ASC'
Есть две таблицы tab1 и tab2
id в tab1 и tab2 соответствуют одному посту
var from = $("#range_51").data("ionRangeSlider").result.from
var to = $("#range_51").data("ionRangeSlider").result.to<form action="/test.php" method="get"><input id="range_51" value="50;950"></form>
SELECT * FROM `table` WHERE id >= 23 AND 'id' <= 256SELECT * FROM `table` WHERE id > 22 AND 'id' < 257$result = mysqli_query($link, "SELECT * FROM `table` WHERE id >= 23 AND 'id' <= 256");$result = mysqli_query($link, "SELECT * FROM `table` WHERE id >= '".$var1."' AND 'id' <= '".$var2."' ");$result = $mysqli->query("SELECT * FROM `table` WHERE id >= '".$var1."' AND 'id' <= '".$var2."' ");
<select id="sel" onchange="selectCity()">
<optgroup label="Выберите страну">
<option value="bel">Белоруссия</option>
<option value="rus">Россия</option>
<option value="ukr">Украина</option>
</select>
<script>
function selectCity(){
var id_region = $('select[name="region"]').val();
$.ajax({
url: "index.php?r=sgpc",
data: { action: 'showCityForInsert', id_region: sel.value },
cache: false,
success: function(responce){ $('div[name="selectDataCity"]').html(responce); }
});
};
</script>
<div class="container">
<div class="row">
<h1>Bootstrap Tabs</h1>
<div class="tabbable">
<ul class="nav nav-tabs">
<li class="active"><a href="#tab1" data-toggle="tab">Section 1</a></li>
<li><a href="#tab2" data-toggle="tab">Section 2</a></li>
<li><a href="#tab3" data-toggle="tab">Section 3</a></li>
</ul>
<div class="tab-content">
<div class="tab-pane active" id="tab1">
<p>I'm in Section 1.</p>
</div>
<div class="tab-pane" id="tab2">
<p>I'm in Section 2.</p>
</div>
<div class="tab-pane" id="tab3">
<p>I'm in Section 3.</p>
</div>
</div>
</div>
</div>
</div>$(function(){
var hash = window.location.hash;
hash && $('ul.nav a[href="' + hash + '"]').tab('show');
$('.nav-tabs a').click(function (e) {
$(this).tab('show');
var scrollmem = $('body').scrollTop();
window.location.hash = this.hash;
$('html,body').scrollTop(scrollmem);
});
});
