Get Row and Get Result from Global $wpdb

Get Row and Get Result from Global $wpdb
public static function get_juridiction_city_from_user_zip($zipcode){

		global $wpdb; 
		$sql = "SELECT * FROM ".$wpdb->prefix."dk_speakout_parish_zip WHERE zipcode =".$zipcode ;

    	$result = $wpdb->get_row( $sql );

		if ( $result  ) {
			$city = $result->city;
		}

		if($city){
			$citysql  = "SELECT * FROM ".$wpdb->prefix."dk_speakout_parish WHERE city = '".$city."' ";
			$parishes =  $wpdb->get_results($citysql);

			return    $parishes; 
		}


	}

Leave a Reply

Your email address will not be published. Required fields are marked *