johnrage

Thanks man, partially I got it working the search query. It retrieve now to the db and display results however I need to refine it further. The query displays all the names of the “doctor”. How could I extract the input string so that specific names only will appear in the results.

[ Moderator Note: Please post code or markup snippets between backticks or use the code button. It makes the code much easier to read and follow. ]

<?php
	global $wpdb;
	$metavalue = $_GET['s'];
	$selectvalue = $_GET['select_pros'];

	if ($selectvalue == 'doctor') {

		//Query All Description with Doctor
		$att_qry = "SELECT *
			FROM $wpdb->usermeta
			WHERE meta_key='description'
			AND meta_value='doctor'
			LIKE meta_value='$metavalue%'
			";

		$att_qry_results = $wpdb->get_results($att_qry);
		  foreach ($att_qry_results as $att_qry_result) {

			//Query User Information
			$userinfo=get_userdata( $att_qry_result->user_id );

			//Display Results
			echo '
<li>' . $userinfo->first_name . ' ' . $userinfo->last_name . '</li>
';

			}
	}

Thanks for the quick response appreciated. Can you point me other detailed references how to work around with the search page that address to my questions above?

I am not that good in adding codes. Do you have any example how the widget will appear in the right side bar?