Year:Select'; foreach (range(date('Y'), $earliest_year) as $x) { if($already_selected_value == $x) echo ''.$x.''; else echo ''.$x.''; } echo ''; ?> Month:Select'; for ($m=1; $m<=12; $m++) { if($sel_mnth == $m) echo ' ' . date('M', mktime(0,0,0,$m)) . ''; else echo ' ' . date('M', mktime(0,0,0,$m)) . ''; } echo ''; ?> Go

Initiative:get_results($sql); $count = count($pgs); if($count > 0){ if (isset($_POST['isubmit'])) $sel_initiate = $_POST['einitiative']; else if (isset($_GET['einitiative'])) $sel_initiate = $_GET['einitiative']; echo 'Select'; for($i = 0; $i < $count; $i++) { if($sel_initiate == $pgs[$i]->post_id) echo '' . $pgs[$i]->post_title . ''; else echo '' . $pgs[$i]->post_title . ''; } echo ""; } ?> Go

States:get_results($state_sql); $state_count = count($state_pgs); if($state_count > 0){ if (isset($_POST['ssubmit'])) $sel_state = $_POST['estate']; else if (isset($_GET['estate'])) $sel_state = $_GET['estate']; echo 'Select'; for($i = 0; $i < $state_count; $i++) { if($sel_state == $state_pgs[$i]->post_id) echo '' . $state_pgs[$i]->post_title . ''; else echo '' . $state_pgs[$i]->post_title . ''; } echo ""; } ?> Go

get_results($msql); $pagecount = count($pages1); $pages = $wpdb->get_results($sql); $count = count($pages); if($eyear!="select" || $txt!="select" || $stateTxt !="select"){ if($pagecount > 0) { if(isset($_POST['ssubmit']) || isset($_POST['isubmit']) || isset($_GET['einitiative']) || isset($_GET['estate'])) { ?>

Listing the cases of .

ID." )"; $image_data = $wpdb->get_results($sqlimage); $sqlstrtdate = "(SELECT meta_value FROM wp_postmeta WHERE meta_key = 'date' AND post_id = ".$pages[$i]->ID." )"; $strtdate_data = $wpdb->get_results($sqlstrtdate); $sqlenddate = "(SELECT meta_value FROM wp_postmeta WHERE meta_key = 'end_date' AND post_id = ".$pages[$i]->ID." )"; $enddate_data = $wpdb->get_results($sqlenddate); $sqlvenue = "(SELECT meta_value FROM wp_postmeta WHERE meta_key = 'venue' AND post_id = ".$pages[$i]->ID." )"; $venue = $wpdb->get_results($sqlvenue); $sqlword="(SELECT post_content FROM wp_posts WHERE ID = ".$pages[$i]->ID.")"; $words = $wpdb->get_results($sqlword); ?> No records found of cases. Please refine your search and try again.