$sql_pos = "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() 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"]) . " | ";
?>
|
 |
 |
|
|
 |
|
|
|
|
|
// current presentations
$sql=" SELECT id, name, image,
date_format(data, '%d.%m.%Y | %H:%i') as data,
date_format(data_begin, '%d.%m') as data_begin,
date_format(data_end, '%d.%m') as data_end
FROM gx_content
WHERE cat = 31 AND data_begin <= sysdate() AND data_end >= sysdate()
ORDER BY data_begin, data DESC
LIMIT 4";
$result = mysqli_query($sql);
if ($result) {
echo " Текущие ";
while ($row = mysqli_fetch_array($result)) {
echo "  с ".$row["data_begin"]." по ".$row["data_end"]."
";
}
}
?>
|
$sql=" select id, name, image,
date_format(data, '%d.%m.%Y | %H:%i') as data,
date_format(data_begin, '%d.%m') as data_begin,
date_format(data_begin, '%m%d') as data_order,
date_format(data_end, '%d.%m') as data_end
from gx_content
where cat = 31 and data_begin > 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"]."
";
}
}
?>
|
|
 |
|
|
 |
|
$sql=" select id, name, image, anons, date_format(data, '%d.%m.%Y | %H:%i') as data
from gx_content
where cat = 101 and active = 1
order by id desc limit 2";
$result = mysqli_query($sql);
$row = mysqli_fetch_array($result);
echo "
|
".$row["anons"]." | ";
$row = mysqli_fetch_array($result);
echo " |
".$row["anons"]." | ";
?>
|
// include('functions/gx_c_banner.php'); ?> |
|