require_once('adminka/misc/keramika_base.php');
mysql_select_db($database_keramika_base, $keramika_base);
$adminka = $_SERVER['PHP_SELF'];
$imgpath = "images/news/";
?>
|
|
Новости
$query_rs_tabdata = "SELECT id, news_date, news_name, news_text FROM news ORDER BY news_date DESC";
$rs_tabdata = mysql_query($query_rs_tabdata, $keramika_base) or die(mysql_error());
$row_rs_tabdata = mysql_fetch_assoc($rs_tabdata);
$totalRows_rs_tabdata = mysql_num_rows($rs_tabdata); //кол-во строк в таблице
if ($totalRows_rs_tabdata>0) { do {//цикл строк таблицы
$current_news = $row_rs_tabdata['id'];
?>
|
|
//выводим картинки
$query_photos = "SELECT id, news_id FROM news_images WHERE news_id=$current_news ORDER BY id";
$photos = mysql_query($query_photos, $keramika_base) or die(mysql_error());
$row_photos = mysql_fetch_assoc($photos);
$totalRows_row_photos = mysql_num_rows($photos); //кол-во картинок
if ($totalRows_row_photos>0) {
do { ?>
|
|
|
|