query($sql);
$numrows = mysqli_num_rows($result);
while($row = mysqli_fetch_array($result)){
$article_id = $row['article_id'];
$isssue = $row['isssue'];
$author_id = $row['author_id'];
$magazine_name = $row['magazine_name'];
$date_issue_from = $row['date_issue_from'];
$themagazine_name = $magazine_name;
$themonth = date("m", strtotime($date_issue_from));
$theyear = date("Y", strtotime($date_issue_from));
$themagazine_name = $row['magazine_name'];
$themagazine_name = str_replace(" ","-",$themagazine_name);
$mymagazinelink = $theyear."/".$themonth."/".$themagazine_name;
$magazine_id = $row['magazine_id'];
$article_name = $row['article_name'];
$the_article_name = str_replace("/"," - ",$article_name);
$the_article_name = urlencode($the_article_name);
$article_image = $row['article_image'];
$article_video = $row['article_video'];
$article_body = $row['article_body'];
$article_body = strip_tags($article_body);
$article_body = substr($article_body,0,125);
$thename = $row['thename'];
$linkname = str_replace(" ","-",$thename);
$linkname = str_replace(" ","-",$thename);
$artilcelink = $article_id."/".$the_article_name;
$url = "www.gohub.co.ke/article/$artilcelink";
?>
