query($lekerdezem); $osszes_rekord = mysqli_fetch_array($result_count); $osszes_rekord = $osszes_rekord['osszes_rekord']; $osszes_oldalak_szama = ceil($osszes_rekord / $osszes_rekord_oldalankent); $second_last = $osszes_oldalak_szama - 1; // total page minus 1 /* leszükitett feltételes */ if (isset($category)) { if ($category == 188) { $add = "WHERE posts_categories.categoryId=195 OR posts_categories.categoryId=197 OR posts_categories.categoryId=188"; } if ($category == 189) { $add = "WHERE posts_categories.categoryId=200 OR posts_categories.categoryId=189"; } if ($category == 191) { $add = "WHERE posts_categories.categoryId=198 OR posts_categories.categoryId=199 OR posts_categories.categoryId=191"; } if ($category == 188 || $category == 189 || $category == 191) { $resultom = "SELECT * FROM posts LEFT JOIN posts_categories ON posts.id=posts_categories.postId " . $add; } else { $resultom = "SELECT * FROM posts LEFT JOIN posts_categories ON posts.id=posts_categories.postId WHERE posts_categories.categoryId=".$category; } $resultom .= " AND posts.status='APPROVED' ORDER BY approveOn DESC LIMIT $offset, $osszes_rekord_oldalankent"; } else { $resultom = "SELECT * FROM posts LEFT JOIN posts_categories ON posts.id=posts_categories.postId WHERE posts_categories.categoryId>187 AND posts.status='APPROVED' ORDER BY approveOn DESC LIMIT $offset, $osszes_rekord_oldalankent"; } /* munkához kibövitett feltételes */ $result = $conn->query($resultom); $talalatok_szama = $result->num_rows; ?>
187 && $category < 192) { $resultMainMenu = "SELECT * FROM categories WHERE parentid =" . $category . " ORDER BY sequence"; } else if ($category > 191) { $szulo = $conn->query("SELECT * FROM categories WHERE id =" . $category); $resultMainMenu = "SELECT * FROM categories WHERE parentid =" . $szulo->fetch_row()[1] . " ORDER BY sequence"; } */ } else { $resultMainMenu = "SELECT * FROM categories WHERE id > 193 ORDER BY sequence"; } $temak_lekerdezese = $conn->query($resultMainMenu); // első szintü szerkezetfelépítés kezdő UL paramétere echo "
    "; $i = 1; while ($aktualis_kategoria = $temak_lekerdezese->fetch_assoc()) { $aktiv_kategoria = $aktualis_kategoria['id']; $resultSubMenu = "SELECT * FROM categories WHERE parentid =" . $aktiv_kategoria; $temak_lekerdezese_sub = $conn->query($resultSubMenu); if ($temak_lekerdezese_sub->num_rows > 0) { echo '
  • '; echo $aktualis_kategoria['name']; echo '
    nyil
    '; if ($temak_lekerdezese_sub->num_rows > 0) { echo '"; } // if vége echo "
    • "; } else { // első szintü szerkezetfelépítés echo "
  • "; echo '"; echo $aktualis_kategoria['name']; echo ""; echo "
    • "; } $i++; } echo '
' ?>
query($query_categoria); while($row = mysqli_fetch_assoc($query_categoria)) { echo $row['name']; } }else { echo 'Témák'; } ?>

query($query_categoria); while($row = mysqli_fetch_assoc($query_categoria)) { echo substr($row['description'],0, 230); } }else { $query_focategoria = "SELECT * FROM categories WHERE id = 128"; $query_focategoria = $conn->query($query_focategoria); while($row = mysqli_fetch_assoc($query_focategoria)) { echo substr($row['description'],0, 230); } } ?>

*/ ?>

query($query_categoria); while ($row = mysqli_fetch_assoc($query_categoria)) { echo $row['name']; } } else { echo 'Tartalmak'; } ?>

fetch_assoc(); echo '
'; if (isset($sor['imageMediaId'])) { echo ''; echo '' . stripslashes($sor['title']) . ''; echo ''; } else { echo 'Nincs kép'; } echo '

' . substr(htmlspecialchars(stripslashes($sor['title'])), 0, 130) . '

' . substr(htmlspecialchars_decode($sor['lead']), 0, 170) . '

Tovább
'; } /*cikkgenerátor vége*/ ?> close(); ?>