SQL Query inside Widget

"SELECT name FROM wp_venues WHERE name="".the_field("venue')."' ";
will only return the value of the_field('venue') which is already known.

"SELECT * FROM wp_venues WHERE name="".the_field("venue')."' "; will select the whole row with all fields.

Try too use $wpdb->prepare for security reasons.

With $wpdb->get_row you get the whole row as either an object, a numerically indexed array or an associative array. See the codex on get_row.

For example you could do the following:

$row = $wpdb->get_row( $wpdb->prepare("SELECT * FROM wp_venues WHERE name = %s", the_field('venue')));
echo "Name: ".$row->name."\n";
echo "Capacity: ".$row->capacity."\n";
echo "Image: ".$row->image."\n";
echo "Description: ".$row->description."\n";

Debugging

Try what is mentioned in the codex : http://codex.wordpress.org/Class_Reference/wpdb#Show_and_Hide_SQL_Errors and turn on WP_DEBUG in wp-config.php.

In addition : $wpdb->last_query can be looked up to show the last query used. Retrieve the query, that is actually executed and try this query manually and see which results there are.

Literature

Related Posts:

  1. meta_query ‘compare’ => ‘IN’ not working
  2. Use the page slug in a WP_Query?
  3. Sorting: custom query with orderby meta_value_num THEN by title
  4. WP_Query and next_posts_link
  5. Using OR conditions in meta_query for query_posts argument
  6. Sanitation needed for WP_Query or get_posts calls?
  7. count posts from custom taxonomy terms by year
  8. replace the WP_Query class in the main query
  9. Woocommerce query by price range and custom meta key
  10. Get posts with condition on comment meta value
  11. WP_Query sort by comment meta data
  12. Limit search results to exact match
  13. Move posts to top of WP_Query if in certain Taxonomy?
  14. WP_query ‘orderby=none’ Problem
  15. ‘paged’ in wp_query doesn’t work
  16. Sorting meta_value as integer doesn’t work
  17. Display different number of posts from one category on the different pages
  18. How to display child posts in the parent category
  19. WP_Query hit max joins… How else can I build a search function that uses custom fields?
  20. Custom Field Query – Meta Value is Array
  21. How to count data records in wordpress which have same meta_value in wp_postmeta table?
  22. Order terms inside a select dropdown
  23. WP_Query for showing specific post by id
  24. Ordering by meta_value AND date NOT WORKING with wp_query
  25. Transient caching for wp query
  26. WP_Query orderby breaks when using AJAX?
  27. How To Get Some Data From WordPress Database Using WordPress $wpdb Query?
  28. Using $paged redirects /page/2 to page 1
  29. Why wont this wp_query exclude certain pages?
  30. How do I change database charset when using `wpdb`
  31. WP_Query attachments by multiple IDs
  32. get_posts – get all posts by array of author
  33. Query “Category A” + 1 post from “Category B” – how?
  34. WP_Query To call data from diffrent tables
  35. new WP_Query with author argument return no results
  36. How to combine two or more WP_Query?
  37. Assigning a meta_query value based on regexp to wp_query fails
  38. Getting Taxonomy inside WP_Query Loop
  39. WP_Query custom query showing only 10 posts on all pages
  40. Not getting metavalue
  41. Ajax load more posts – WP_Query parameters not working
  42. Display Featured Post by Categories and Avoid duplicated posts
  43. How to display multiple custom fields with the same meta_key in an ascending order?
  44. Using the_post_thumbnail resets current loop item ID
  45. How to show optimized list of posts with all their attachment images
  46. Posts not showing per category after WP_Query?
  47. wp_query exclude word and category
  48. Assign Json file to WP_Query
  49. How can I query users by custom role?
  50. Pagination inside of a edit page
  51. Problem with is_tax in WP_Query loop
  52. Removing duplicate values between two wordpress queries
  53. Issue with front page navigation after upgrading to 3.4
  54. Ordering posts by an array
  55. Exclude recently updated post from custom WP_Query using multiple loops
  56. get_posts output always same post
  57. WordPress Custom Search Form Displaying Unexpected Results
  58. Stomping WP_Query in author archive to facilitate pagination with custom queries
  59. Limit number of posts in loop
  60. How do I get Woocommerce product variation name and variation description in a WP_Query?
  61. Loop posts based on permalink term
  62. WP_Query offset is returning post from prevois loop
  63. Does WP_Query ‘responds’ badly to empty arguments?
  64. Does putting queries within loops cause an issue on WordPress?
  65. How to get current page nearest parent id?
  66. How to create Page templates for showing Blog posts in different layouts?
  67. How to get only ONE category of “Portfolio” posts to display on main page rather than ALL categories?
  68. Determining what post is displayed out of total posts found
  69. Adding query parameter to archive page returns 404
  70. Strange behaviour of hierarchical taxonomy archive
  71. Is it normal that get_post() gets run 300 times and the content of those posts aren’t visible?
  72. WordPress AJAX Request returns 400
  73. Using wpdb prepare with a variable, turns it into a big string
  74. WordPress Sub Category Archive, Show Extra Empty Page Number in Pagination
  75. SQL to join u3g_users & u3g_meta_value with repeating data
  76. Doing $wpdb->get_results returns NULL, doing the same query in my DB returns correct value
  77. How to get meta key list efficiently?
  78. Get posts having meta value between two numbers
  79. How order by works?
  80. taxquery taxonomy get terms
  81. Separate by Category Post Type
  82. ACF: using two loops, the_field returns field content from another loop
  83. Using modified ‘meta_key’ to set ‘orderby’ in WP_Query?
  84. Combine WP_Query with array of custom data to single loop without breaking the pagination
  85. query_posts() doesn’t seem to be called in my page
  86. Query posts in current category but not attachment format
  87. WP_Query with Pagination and orderby meta_value_num showing duplicates
  88. wp_query – Modify $query to include duplicate content
  89. Optimising specific Query with ACF meta objects
  90. Slow getting posts from category
  91. Pagination not working with WP_Query (creates links but no page)
  92. WP Query posts__in not working with array
  93. Query Posts by date range with fixed beginning and end
  94. Query specific number of posts for each post type in specific order
  95. Avoiding page loop
  96. Query Users by post count, last 30 days and display each users post count according to post type
  97. how do I exclude child categories from a wp_query?
  98. How to create a loop inside WP_Query?
  99. how to show only catergory titles on a page in wordpress
  100. WP Query returning all posts when Meta_query is null