Recent News Items

' . $pages->display_pages() . '
  ' . $pages->display_jump_menu() . '  ' . $pages->display_items_per_page() . ''; echo '
'; //count articles so we can place some ads...need total of three $ad_count = 0; //display articles while ( $row = $zdb->fetch($result) ){ $ad_count++; if ( ( $ad_count == 4 ) || ( $ad_count == 7 ) ){ echo '
'; echo '
'; } //get channel info (merge this all into a single query once you learn how to join properly) $query = "SELECT * FROM channels WHERE id='" . $row['channel'] . "'"; $result2 = $zdb->query($query); $row2 = $zdb->fetch($result2); //create SEO URL $urltitle = clean_url($row['title']); $urltitle = urlencode($urltitle); if ( $row['regreason'] == "1" ){ $regreason = ' title="Determined by location names within the article."'; } else if ( $row['regreason'] == "2" ){ $regreason = ' title="Assigned by RSS Feed geo-location."'; } else { $regreason = ' title="Determined by proprietary formulation."'; } echo '

' . str_replace("%", "", $row['title']) . '

'; echo ''; echo '
'; if ( $row['summary'] ){ //prepare content $tmp = html_entity_decode($row['summary']); echo '

' . $tmp . '

'; } else { $tmp = html_entity_decode($row['content']); echo '

' . $tmp . '

'; } echo ''; echo '

' . $row['url'] . '

'; echo '
'; echo '
'; echo '
'; } ?> ' . $pages->display_pages() . '
  ' . $pages->display_jump_menu() . '  ' . $pages->display_items_per_page() . ''; ?>