// get a listing of all of the articles that apply
// count the applicable articles
$result_blogs = mysqli_query($conn, "SELECT * FROM blogs ORDER by publish_date DESC");
while ($query_data_blogs = mysqli_fetch_assoc($result_blogs))
{
$blog_id = $query_data_blogs["blog_id"];
$title = $query_data_blogs["title"];
$header_image = $query_data_blogs["header_image"];
$flavour_text = $query_data_blogs["flavour_text"];
$code = $query_data_blogs["code"];
$publish_date = date_create($query_data_blogs["publish_date"]);
$url = $query_data_blogs["url"];
// Get a listing of all the tags for this blog
$tags_string = "";
$result_tags = mysqli_query($conn, "SELECT * FROM tags_to_blogs where blog_id = " . $blog_id);
while ($query_data_tags = mysqli_fetch_assoc($result_tags))
{
$tag_id = $query_data_tags["tag_id"];
// get the tag name from the database
$result_tag_info = mysqli_query($conn, "SELECT * FROM tags where tag_id = " . $tag_id . " AND tag_name NOT LIKE '%Newsletter%'");
while ($query_data_tag_info = mysqli_fetch_assoc($result_tag_info))
{
$tag_name = $query_data_tag_info["tag_name"];
if($tag_name=="Personal and Estate")
{
$tag_name = "PersonalAndEstate";
}
if($tag_name=="Financial Planning")
{
$tag_name = "Financialplanning";
}
}
$tags_string = $tags_string . " " . $tag_name;
?>
}
?>
}
// this section is for static newsletter cards
?>
Fall 2021 Newsletter
Read
Winter 2020 Newsletter
Read