<?php 
include 'tpl.php';
$tpl_data['pr']='';
$q = mysql_query("SELECT count(memberid) as count FROM `members` LIMIT 1");
$mem_count = mysql_fetch_assoc($q);
$tpl_data['mem_count'] = $mem_count = round ( $mem_count['count'],-2);

$q = mysql_query("SELECT count(adid) as count FROM `ads`");
$list_count = mysql_fetch_assoc($q);
$tpl_data['list_count'] = $list_count = round ( $list_count['count'],-2);

$c_q = mysql_query("SELECT sum(pop) as c_count FROM `cats`") or die(mysql_error());
$l_q = mysql_query("SELECT SUM(pop) as l_count FROM `locations`") or die(mysql_error());
$cats_count = mysql_fetch_assoc($c_q);
$loc_count = mysql_fetch_assoc($l_q);
$tpl_data['pop_count'] = $pop_count = round ( ($cats_count['c_count']+$loc_count['l_count']),-2);

$q = mysql_query("SELECT * FROM `ads` WHERE `active`='1' ORDER BY adid DESC LIMIT 10");
while($row = mysql_fetch_assoc($q)){
    //print_r($row);
    foreach($row as $k=>$v){
        ${'p_'.$k} = $v;
    }
    $p_image = ($p_image?'/members/uploads/logo/'.$p_image:'/img/no_logo.png');
    $p_description = strlen($p_description) > 200 ? trim(substr($p_description,0,200),"\s")."..." : $p_description;
    $tpl_data['pr'].='
    <div class="product two_view">
        <div class="inner_cn">
            <div class="pr_img"><a href=""><img src="'.$p_image.'"></a></div>
            <div class="pr_details">
                <a href="" class="pr_title">'.$p_companyname.'</a>
                <div href="" class="pr_desc">'.$p_description.'</div>
                <a href="">See more...</a>
            </div>        
        </div>
    </div>';
}


$tpl = curl('hompage.html');
$tpl_data['header'] = curl('header.html');
say($tpl,$tpl_data,false);
?>