NOW() and pos IS NOT NULL
order by pos limit 5";
$sql_content_pos = mysqli_query($sql_pos);
$sql = "select id, name, image, anons, pos, date_format(data_end, '%Y%m%d') as data_end, date_format(data, '%d.%m.%Y | %H:%i') as data
from gx_content
where cat = 24 and active = 1 and data_end < NOW()
order by id desc limit 5";
$sql_content = mysqli_query($sql);
if (mysqli_num_rows($sql_content_pos)>0) {
for ($data1=array(); $row1=mysqli_fetch_assoc($sql_content_pos); $data1[(int)$row1["pos"]-1]=$row1) {
echo "";
}
for ($data=array(); $row=mysqli_fetch_assoc($sql_content); $data[]=$row) {
echo "";
}
for ($i=0; $i<5; $i++) {
if ($data1[$i]==false) {
$data1[$i]=$data[$i];
}
}
} else {
for ($data1=array(); $row=mysqli_fetch_assoc($sql_content); $data1[]=$row)
echo "";
}
for ($j=0; $j<5; $j++) {
$row[$j]=$data1[$j];
}
echo "| " . NovostAsString ($row["0"]["id"], $row["0"]["name"], $row["0"]["anons"], $row["0"]["image"]) . " | ";
echo "| " . NovostAsStringShort($row["1"]["id"], $row["1"]["name"], $row["1"]["anons"]) . " | ";
echo "| " . NovostAsStringShort($row["2"]["id"], $row["2"]["name"], $row["2"]["anons"]) . " | ";
?>
|
 |
|
|
|
|
|
|
|
|
|
= sysdate()
ORDER BY data_begin, data DESC
LIMIT 4";
$result = mysqli_query($sql);
if ($result) {
echo " Текущие ";
while ($row = mysqli_fetch_array($result)) {
echo " ![](\"/design/4/okei.jpg\") с ".$row["data_begin"]." по ".$row["data_end"]." |
sysdate()
order by data_order asc limit 4 ";
$result = mysqli_query($sql);
if ((mysqli_num_rows($result))>0) {
echo " Ближайшие ";
while ($row = mysqli_fetch_array($result)) {
echo " с ".$row["data_begin"]." по ".$row["data_end"]." |
|
|
|
|
|
|
".$row["anons"]." | ";
$row = mysqli_fetch_array($result);
echo " |
".$row["anons"]." | ";
?>
|
|
|
