query($sql)) {
$partner_count = mysqli_num_rows($result);
} else {
$partner_count = "215";
}
//years of experience
$sql = "SELECT SUM( (
YEAR( CURDATE( ) ) - YEAR( cb_blogcfostartdate ) )
) AS experience
FROM (
SELECT DISTINCT p.user_id, cb_blogcfostartdate
FROM jos_comprofiler AS p
LEFT JOIN jos_users AS u ON u.id = p.user_id
LEFT JOIN jos_b2b_ids AS ids ON ids.joomlaid = p.user_id
LEFT JOIN jos_b2b_bio AS b ON b.bioid = ids.bioid
WHERE b.partner = 't'
AND b.status =1
AND u.usertype != 'Super Administrator'
AND u.block =0
AND p.approved =1
AND cb_blogcfostartdate != '0000-00-00'
) AS mytable";
if ($result = $mysqli->query($sql)) {
while($obj = $result->fetch_object()){
$line=$obj->experience;
}
$yearsofexperience = number_format($line);
} else {
$yearsofexperience = number_format("6500");
}
?>
46 States | Over =$yearsofexperience?> Years of Experience | =$partner_count?> Professionals
No match found.'; ?>
query( $sql ) ) {
while ( $obj = $res->fetch_object() ) {
$states[$obj->cb_state] = $obj->state_name;
}
}
//collect non empty bio state
$sql = "SELECT b.*, p.*, u.name, u.username, u.email, " .
"(SELECT name FROM jos_b2b_state WHERE abrv = p.cb_state LIMIT 1) AS state_name ".
"FROM jos_comprofiler AS p " .
"LEFT JOIN jos_users AS u ON u.id=p.user_id " .
"LEFT JOIN jos_b2b_ids AS ids ON ids.joomlaid=p.user_id " .
"LEFT JOIN jos_b2b_bio AS b ON b.bioid=ids.bioid " .
"WHERE status=1 ".
"AND u.block =0 ".
"AND p.approved =1 ";
if ( is_array($bioid) && count($bioid) > 0 ){
$sql .= "AND b.bioid IN (" . implode(",", $bioid) . ")";
}
$sql .= "ORDER BY p.cb_state ASC, p.cb_displayname ASC";
$state = '';
if ( $res = $mysqli->query( $sql ) ) {
while ( $obj = $res->fetch_object() ) {
if ( $state != $obj->cb_state ){
if ( $state != '' ) echo '