'; $bottom = '

'; if (have_posts($_REQUEST['tags'])) { //$and = " AND ( poll_post_date BETWEEN '$lastmonth' AND '$today' ) "; //$other_and = " AND ( other_poll_post_date BETWEEN '$lastmonth' AND '$today' ) "; $tags = $_REQUEST['tags']; include 'includes/states_list.php'; $state_short = ''; $state = ''; foreach($state_list as $key => $s) { if($s != '' && strpos($tags, $s) === 0) { $state_short = $key; $state = $s; } } $category = trim(str_replace($state, '', urldecode($tags))); $charts = &DBQuery("select * from chart_locations where page = 'swing_state' and chart_type = '$category' and state = '$state_short'"); if($charts->num_rows > 0) { //include 'load_chart.php'; $charts = $charts->fetch_assoc(); $poll = &DBQuery("select poll_candidate_1_id,poll_candidate_2_id from poll where poll_election_type = '$category' and poll_geography = '$state_short' order by poll_id desc limit 1"); $poll = mysqli_fetch_assoc($poll); $cand1 = &DBQuery("select name from candidate where candidate_id = '$poll[poll_candidate_1_id]'"); $cand1 = mysqli_fetch_assoc($cand1); $cand2 = &DBQuery("select name from candidate where candidate_id = '$poll[poll_candidate_2_id]'"); $cand2 = mysqli_fetch_assoc($cand2); echo ' '; echo '

This graph reflects average of polls, not the results of a single poll. more info!

To use our chart on your blog or website, copy and paste the embed code below into your website

'; } $sql = " SELECT which, poll_id, poll_state, cur_timestamp, poll_permalink, poll_post_date, YEAR(poll_post_date) AS year, MONTH(poll_post_date) AS month FROM ( SELECT 'poll' AS which, cur_timestamp, poll_id AS poll_id, poll.poll_geography AS poll_state, poll_permalink AS poll_permalink, poll_post_date AS poll_post_date FROM poll WHERE exclude = 0 AND ( poll_tag_1 = '$tags' OR poll_tag_2 = '$tags' OR poll_tag_3 = '$tags' OR poll_tag_4 = '$tags' OR poll_tag_5 = '$tags' ) UNION SELECT 'other_poll' AS which, cur_timestamp, other_poll_id AS poll_id, other_poll.other_poll_geography AS poll_state, other_poll_permalink AS poll_permalink, other_poll_post_date AS poll_post_date FROM other_poll WHERE exclude = 0 AND ( other_poll_tag_1 = '$tags' OR other_poll_tag_2 = '$tags' OR other_poll_tag_3 = '$tags' OR other_poll_tag_4 = '$tags' OR other_poll_tag_5 = '$tags' ) ) AS fa ORDER BY fa.poll_post_date DESC, fa.cur_timestamp DESC, fa.poll_id DESC LIMIT $offset, $recordsPerPage"; $result = &DBQuery($sql); $ads_count = 0; while ($row = $result->fetch_assoc()){ $folder = "election-polls-" . $row['month'] . "-" . $row['year']; $filename = $row['poll_permalink']; $ads_count++; ?>

fetch_assoc(); if ( $row_which['poll_candidate_1_result'] >= $row_which['poll_candidate_2_result']) { $second_title_photo = the_title_photo_2($row['poll_id']); $first_title_photo = the_title_photo_1($row['poll_id']); } else { $second_title_photo = the_title_photo_1($row['poll_id']); $first_title_photo = the_title_photo_2($row['poll_id']); } $spread = the_spread($row['poll_id']); $tags = the_tags($row['poll_id']); $img = $row['poll_state']; $state = '

'; } elseif ($row['which'] == 'other_poll') { $permalink = $row['poll_permalink']; $title = the_title_other($row['poll_id']); $first_title_photo = the_title_photo_other($row['poll_id'],1); $second_title_photo = the_title_photo_other($row['poll_id'],0); $spread = the_spread_other($row['poll_id']); $tags = the_tags_other($row['poll_id'],1,0); $img = $row['poll_state']; $state = '

'; } ?>

.html">

'; echo file_get_contents('mobile_ads.txt'); echo ''; } } // end .while $tags = $_REQUEST['tags']; $sql = "SELECT COUNT(poll_id) AS num FROM ( SELECT poll_id AS poll_id FROM poll WHERE exclude = 0 AND ( poll_tag_1 = '$tags' OR poll_tag_2 = '$tags' OR poll_tag_3 = '$tags' OR poll_tag_4 = '$tags' OR poll_tag_5 = '$tags' ) UNION SELECT other_poll_id AS poll_id FROM other_poll WHERE exclude = 0 AND ( other_poll_tag_1 = '$tags' OR other_poll_tag_2 = '$tags' OR other_poll_tag_3 = '$tags' OR other_poll_tag_4 = '$tags' OR other_poll_tag_5 = '$tags' ) ) AS fa"; $result = &DBQuery($sql); $row = $result->fetch_assoc(); $numrows = $row['num']; $maxPage = ceil($numrows/$recordsPerPage); $nav = ''; $threeDots = true; $pageNumbers = array(); for($page = 1; $page <= $maxPage; $page++) { if(!in_array($page, $pageNumbers)) { if(($pageNum > 4 && $page < 3) || $pageNum == 4 && $page == 1) { array_push($pageNumbers, $page); $nav .= "

$page

"; } } if($pageNum > 5 && $page == 3) { $nav .= "

...

"; } if(!in_array($page, $pageNumbers)) { if(($page >= ($pageNum-2) && $page <= ($pageNum+2)) || $pageNum == ($page-2) ) { array_push($pageNumbers, $page); if ($page == $pageNum) $nav .= "

$page

"; else $nav .= "

$page

"; } } if($page >= ($pageNum+2) && $maxPage > ($pageNum+4) && $threeDots) { $nav .= "

...

"; $threeDots = false; } if(!in_array($page, $pageNumbers)) { if($pageNum <= ($maxPage-3) && $page > ($maxPage-2)) { array_push($pageNumbers, $page); $nav .= "

$page

"; } } } if ($pageNum > 1) { $page = $pageNum - 1; $prev = "

"; $first = "

"; } else { $prev = ''; $first = ''; } if ($pageNum < $maxPage) { $page = $pageNum + 1; $next = "

"; $last = "

"; } else { $next = ''; $last = ''; } echo "

$first $prev $nav $next $last

"; } // end .if else { include('includes/no-results.php'); } ?>