mabufoysal

Thanks @vijayhardaha. I tried like this but the result is as like before. Thanks.

Thanks @vijayhardaha. I changed it in new Database. URL of both site is https://127.0.0.1/mdc. Thanks.

• This reply was modified 2 years, 8 months ago by mabufoysal.

Thanks @sterndata . I am learning WordPress Development. I am not sure is that the correct key. Thanks.

Thanks @tugbucket . I used like this.

`if($_POST['orga_id']) {
		$users_query = array(
			'meta_query' => array(
				'relation' => 'AND',
				array(
					'relation' => 'OR',
					array(
						'key'     => 'first_name',
						'value'   => $_POST['search'],
						'compare' => 'LIKE'
					),
					array(
						'key' 		=> 'last_name',
						'value' 	=> $_POST['search'],
						'compare' 	=> 'LIKE',
					),
				),
				array(
					'key' 		=> 'organisation',
					'value' 	=> $_POST['orga_id'],
					'compare' 	=> 'LIKE',
				),
				array(
					'key' 		=> 'available',
					'value' 	=>  1,
					'compare' 	=> '=',
				),
				array(
					'orderby' => 'meta_value',
					'meta_key' => 'last_name',
					'order' => 'ASC',
				),
				array(
					'orderby' => 'meta_value',
					'meta_key' => 'first_name',
					'order' => 'ASC',
				),
			)
		);
	} else {
		$users_query = array(
			'meta_query' => array(
				'relation' => 'AND',
				array(
					'relation' => 'OR',
					array(
						'key'     => 'first_name',
						'value'   => $_POST['search'],
						'compare' => 'LIKE'
					),
					array(
						'key' 		=> 'last_name',
						'value' 	=> $_POST['search'],
						'compare' 	=> 'LIKE',
					),
				),
				array(
					'key' 		=> 'available',
					'value' 	=>  1,
					'compare' 	=> '=',
				),
				array(
					'orderby' => 'meta_value',
					'meta_key' => 'last_name',
					'order' => 'ASC',
				),
				array(
					'orderby' => 'meta_value',
					'meta_key' => 'first_name',
					'order' => 'ASC',
				),			
			)
		);
	}

But I am not getting last_name & first_name as output.

Thanks @sebastienserre . Actually I am learning WordPress development. Could you please help me with some sample code ? Thanks.

Thanks @sebastienserre . What should I do if I would like to have asc order of last_name & first_name ?

Thanks @pdclark . Your solution is working. Thanks.