|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$page_query = "SELECT * FROM m_pages WHERE id = '169' AND clientnum = '$ClientNum'";
$desired = mysqli_query($connection,$page_query);
$editshow = mysqli_fetch_array($desired,MYSQLI_BOTH);
$code = $editshow['code'];
print "$code";
$blog_query = "SELECT * FROM m_blog WHERE clientnum = '$ClientNum' AND LiveStatus = 'LIVE' ORDER BY dateblog DESC LIMIT 0, 1";
$desired = mysqli_query($connection,$blog_query);
$howmany = mysqli_num_rows($desired);
$count = 0;
while ($count < $howmany)
{
$editshow = mysqli_fetch_array($desired,MYSQLI_BOTH);
$editposttitle = $editshow['titleblog'];
$editpostcontent = $editshow['entryblog'];
$editpostauthor = $editshow['post_author'];
$editpostauthordate = $editshow['dateblog'];
$editpostauthordateaa = $editpostauthordate;
$editID = $editshow['ID'];
$editpostcontent = substr("$editpostcontent", 0, 800); //this does summary preview of post
$tempInput = explode(" ",$editpostauthordate);
$editpostauthordate = $tempInput[0];
$tempInput = explode("-",$editpostauthordate);
$editpostauthordate1 = $tempInput[0];
$editpostauthordate2 = $tempInput[1];
$editpostauthordate3 = $tempInput[2];
$editpostauthordate = date("F j, Y",strtotime($editpostauthordate));
$editpostcontent2 = $editpostcontent; //this does line breaking
?>
print "$editposttitle"; ?>
print " $editpostcontent...Read more
";
$count++;
}
?>
Click here to view more blog listings... |
|
|
|
|
|
|
|
|
|
|
|
|
|