get_results("select adv_id, count(adv_id) as totals from ".AM_HILI_LINKS." where adv_id > 0 group by adv_id"); if ($am_hili_afi_totals){ foreach ($am_hili_afi_totals as $am_hili_tatal_value){ $am_hili_totals[$am_hili_tatal_value->adv_id] = $am_hili_tatal_value->totals; } } //getting date format from saved options if ($am_hili_options = json_decode(get_am_hili_options('am_hili_options'))){ $am_hili_date_format = $am_hili_options->am_hili_date_format; } else { $am_hili_date_format = "m/d/Y"; } $amHiliSql = "select adv_id, advertiser_name, advertiser_website, advertiser_email, added_on from ".AM_HILI_ADVERTISERS ." order by advertiser_name ASC"; $am_hili_man_rows = $wpdb->get_results($amHiliSql); if ($am_hili_man_rows){ foreach ($am_hili_man_rows as $am_hili_value){ $am_nr++; if ($am_tr_class == "alternate") $am_tr_class = ""; else $am_tr_class = "alternate"; ?>
::
::
advertiser_name;?>
|
advertiser_website)!="")?"advertiser_website."\">".str_replace(array('https://','http://','//','www.'),'',$am_hili_value->advertiser_website)."":"NA";?> advertiser_email)!="")?"advertiser_email."\">".$am_hili_value->advertiser_email."":"NA";?> added_on));?> adv_id]))?$am_hili_totals[$am_hili_value->adv_id]:"0";?>