Title: johnrage's Replies | WordPress.org --- # johnrage [ ](https://wordpress.org/support/users/johnrage/) * [Profile](https://wordpress.org/support/users/johnrage/) * [Topics Started](https://wordpress.org/support/users/johnrage/topics/) * [Replies Created](https://wordpress.org/support/users/johnrage/replies/) * [Reviews Written](https://wordpress.org/support/users/johnrage/reviews/) * [Topics Replied To](https://wordpress.org/support/users/johnrage/replied-to/) * [Engagements](https://wordpress.org/support/users/johnrage/engagements/) * [Favorites](https://wordpress.org/support/users/johnrage/favorites/) Search replies: ## Forum Replies Created Viewing 11 replies - 1 through 11 (of 11 total) * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [How to pass the select value?](https://wordpress.org/support/topic/how-to-pass-the-select-value/) * Thread Starter [johnrage](https://wordpress.org/support/users/johnrage/) * (@johnrage) * [13 years, 9 months ago](https://wordpress.org/support/topic/how-to-pass-the-select-value/#post-2951750) * Working now: * $query = “SELECT user_id FROM $wpdb->usermeta WHERE (meta_value LIKE ‘%%$metavalue%%’) AND (meta_key = ‘first_name’) AND user_id IN (SELECT user_id FROM $wpdb->usermeta WHERE (meta_value= ‘doctor’) AND (meta_key = ‘description’))”; * I found the post in this URL:[http://wordpress.stackexchange.com/questions/28589/search-users-base-on-meta-value-meta-key](http://wordpress.stackexchange.com/questions/28589/search-users-base-on-meta-value-meta-key) * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [How to pass the select value?](https://wordpress.org/support/topic/how-to-pass-the-select-value/) * Thread Starter [johnrage](https://wordpress.org/support/users/johnrage/) * (@johnrage) * [13 years, 9 months ago](https://wordpress.org/support/topic/how-to-pass-the-select-value/#post-2951743) * 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. ]_ * ``` 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 '
  • ' . $userinfo->first_name . ' ' . $userinfo->last_name . '
    • '; } } ``` * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [How to pass the select value?](https://wordpress.org/support/topic/how-to-pass-the-select-value/) * Thread Starter [johnrage](https://wordpress.org/support/users/johnrage/) * (@johnrage) * [13 years, 9 months ago](https://wordpress.org/support/topic/how-to-pass-the-select-value/#post-2951723) * Now I have my query below from my searchform.php and I get a blank result. * _[ Moderator Note: Please post code or markup snippets between backticks or use the code button. ]_ * ``` global $wpdb; $s=(isset($_GET['s'])); $query = mysql_query('SELECT * FROM usermeta WHERE $wpdb->description = $s'); while($row = mysql_fetch_array($query)){ echo $row[0] . ""; } ``` * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [How to pass the select value?](https://wordpress.org/support/topic/how-to-pass-the-select-value/) * Thread Starter [johnrage](https://wordpress.org/support/users/johnrage/) * (@johnrage) * [13 years, 9 months ago](https://wordpress.org/support/topic/how-to-pass-the-select-value/#post-2951603) * 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? * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [Editable Word/Excel in WordPress](https://wordpress.org/support/topic/editable-wordexcel-in-wordpress/) * Thread Starter [johnrage](https://wordpress.org/support/users/johnrage/) * (@johnrage) * [13 years, 9 months ago](https://wordpress.org/support/topic/editable-wordexcel-in-wordpress/#post-2921034) * Well the plugin is not fit as to what I required. I am pretty sure there are few plugins or maybe a reference how to do this. * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [adding image in the recent post widget](https://wordpress.org/support/topic/adding-image-in-the-recent-post-widget/) * Thread Starter [johnrage](https://wordpress.org/support/users/johnrage/) * (@johnrage) * [14 years, 5 months ago](https://wordpress.org/support/topic/adding-image-in-the-recent-post-widget/#post-2439912) * I am not that good in adding codes. Do you have any example how the widget will appear in the right side bar? * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [adding image in the recent post widget](https://wordpress.org/support/topic/adding-image-in-the-recent-post-widget/) * Thread Starter [johnrage](https://wordpress.org/support/users/johnrage/) * (@johnrage) * [14 years, 5 months ago](https://wordpress.org/support/topic/adding-image-in-the-recent-post-widget/#post-2439910) * My wordpress version 3.2.1 * I don’t have any plugins that do this, just the built in wp widgets like recent post. * In any case, what plugins do you recommend to resolve my problem? * Forum: [Themes and Templates](https://wordpress.org/support/forum/themes-and-templates/) In reply to: [Custom Field – Thumbnails](https://wordpress.org/support/topic/custom-field-thumbnails/) * [johnrage](https://wordpress.org/support/users/johnrage/) * (@johnrage) * [17 years, 5 months ago](https://wordpress.org/support/topic/custom-field-thumbnails/#post-778050) * Ivovic i have the same problem, did you fix? * Forum: [Themes and Templates](https://wordpress.org/support/forum/themes-and-templates/) In reply to: [Solution: Sidebar moves down in IE but great in FF](https://wordpress.org/support/topic/solution-sidebar-moves-down-in-ie-but-great-in-ff/) * [johnrage](https://wordpress.org/support/users/johnrage/) * (@johnrage) * [17 years, 5 months ago](https://wordpress.org/support/topic/solution-sidebar-moves-down-in-ie-but-great-in-ff/#post-745096) * how to create a sidebar-wrapper and how to apply it my class? * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [Sidebar issue in different browsers!](https://wordpress.org/support/topic/sidebar-issue-in-different-browsers/) * [johnrage](https://wordpress.org/support/users/johnrage/) * (@johnrage) * [17 years, 5 months ago](https://wordpress.org/support/topic/sidebar-issue-in-different-browsers/#post-915406) * where to find the #sidebar-wrapper. I have the same problem. My page looks fine in Firefox, however the page in IE looks weired. * Herewith is the link for your reference. A screenshot of the webpages in IE and Firefox. * [http://screencast.com/t/f487dc9b](http://screencast.com/t/f487dc9b) * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [Firefox and IE issue.. my site has different looks](https://wordpress.org/support/topic/firefox-and-ie-issue-my-site-has-different-looks/) * Thread Starter [johnrage](https://wordpress.org/support/users/johnrage/) * (@johnrage) * [17 years, 5 months ago](https://wordpress.org/support/topic/firefox-and-ie-issue-my-site-has-different-looks/#post-917026) * Many thanks what a great tool to validate css and html codings. Viewing 11 replies - 1 through 11 (of 11 total)