if ($idCategoria=="") {
$tbPost = mysqli_query($con,"SELECT * FROM post
WHERE status=1
ORDER BY created_at DESC");
$txtCategoria="Todas";
} else {
$tbPost = mysqli_query($con,"SELECT * FROM post
WHERE status=1 AND category_id='$idCategoria'
ORDER BY created_at DESC");
$tbCategorias = mysqli_query($con,"SELECT * FROM category
WHERE id='$idCategoria'");
$rowCat = mysqli_fetch_array($tbCategorias);
$txtCategoria = $rowCat['name'];
}
?>
Entradas Categoría: echo $txtCategoria; ?>
while($row = mysqli_fetch_array($tbPost)) {
$tbCategorias = mysqli_query($con,"SELECT * FROM category
WHERE id=".$row['category_id']);
$rowCat = mysqli_fetch_array($tbCategorias);
$categoria = $rowCat['name'];
$fecha = strtotime($row['created_at']);
?>
}
?>