WHY NOW?
As a country as well as the insurance industry, we now face obstacles unlike any in our nation's history. Together, we can make a difference by charting new territory that will insure the health, well-being and safety of our clients and neighbors. THE CLIP symbolizes our dialogue, holding our ideas and aspirations together as we share information on current events that affect us, our businesses and clientele.
Join us in this journey by adding your feedback while sharing ideas and forming new alliances within our vast community on the web. Our profession has a voice and it will be heard!
//get most recent blog post from database and display it. include('config/dbconnect.php'); $query="SELECT * FROM blogposts WHERE post_id = (SELECT MAX(post_id) FROM blogposts) "; $result=mysql_query($query); $i=0; mysql_close(); $postid=mysql_result($result,$i,"post_id"); $posttime=mysql_result($result,$i,"post_time"); $sectionid=mysql_result($result,$i,"section_id"); $postauthor=mysql_result($result,$i,"post_author"); $posttags=mysql_result($result,$i,"post_tags"); $postcontent=mysql_result($result,$i,"post_content"); $posttitle=mysql_result($result,$i,"post_title"); //get section name from database include('config/dbconnect.php'); $query="SELECT * FROM blogsections WHERE section_id = $sectionid "; $result=mysql_query($query); $i=0; mysql_close(); $sectionid=mysql_result($result,$i,"section_id"); $sectionname=mysql_result($result,$i,"section_name"); //get appropriate blog post responses from database and display. include('config/dbconnect.php'); $query="SELECT * FROM blogresponses WHERE post_id=$postid"; $result=mysql_query($query); $rnum=mysql_numrows($result); if($rnum>0){ $responseauthor=mysql_result($result,$i,"response_author"); $responsecontent=mysql_result($result,$i,"response_content"); } mysql_close(); echo "
$posttitle
Blog Section: $sectionname
Posted by $postauthor
$postcontent
Tagged: $posttags
Post Date: • $posttime •
";
?>
Responses
if($rnum<1){ echo"be the first to respond!"; }else{ $i=0; while ($i < $rnum) { echo" "; ?>
Quick Links
- incSurance.com
- Main Blog Page
- Recent Posts
- Contact Us
- $sectionname "; $i++; } ?>
Blog Sections
//get blog sections from database. Create links and display in the left navigation. include('config/dbconnect.php'); $query="SELECT * FROM blogsections ORDER BY section_sortorder ASC "; $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); $i=0; while ($i < $num) { $sectionname=mysql_result($result,$i,"section_name"); $sectionid=mysql_result($result,$i,"section_id"); echo "CLIPboard Quote
// get a random CLIPboard quote from database and display it include('config/dbconnect.php'); $queryq="SELECT quote_code FROM clipquotes ORDER BY RAND() LIMIT 1"; $result=mysql_query($queryq); $i=0; $quote_code=mysql_result($result,$i,"quote_code"); mysql_close(); echo$quote_code; ?>

$responseauthor says:
$responsecontent