Join Your Local Chapter
get_results( "SELECT * FROM `wp_posts` p, wp_postmeta pm where pm.meta_value='$getcity' AND p.id=pm.post_id;"); // echo "SELECT * FROM `wp_posts` p, wp_postmeta pm where pm.meta_value='$getcity' AND p.id=pm.post_id;"; } elseif(!empty($getcountry) && !empty($getstate)) { // $sql_search="SELECT * FROM `wp_posts` p, wp_postmeta pm where pm.meta_value='Los angelis' AND p.id=pm.post_id;"; $results = $wpdb->get_results( "SELECT * FROM `wp_posts` p, wp_postmeta pm where pm.meta_value='$getstate' AND p.id=pm.post_id;"); } elseif(!empty($getcountry)) { // $sql_search="SELECT * FROM `wp_posts` p, wp_postmeta pm where pm.meta_value='Los angelis' AND p.id=pm.post_id;"; $results = $wpdb->get_results( "SELECT * FROM `wp_posts` p, wp_postmeta pm where pm.meta_value='$getcountry' and pm.meta_key='wpsl_country' AND p.id=pm.post_id;"); } else { } ?>
Test 911
United States
California
Apple Valley
60200
University of Greenwich
Select Country
Select State
Select City
10121
University of California
United States
California
Newport Beach
26233
