Can’t get expected result from a wpdb query

I know I probably can’t see the full picture, but in the excerpt you provided isn’t globalizing $post.

global $wpdb, $post;
$short = $wpdb->get_var("SELECT url FROM $wpdb->prefix.'tweet_url' WHERE post_id = '$post->ID' ");

Related Posts:

  1. $wpdb->get_row() only returns a single row?
  2. How to parse row results from $wpdb -> get_results
  3. what is the way to see the currently executing query in wordpress?
  4. Fetch array with $wpdb
  5. $wpdb->last_error doesn’t show the query on error
  6. Theoretical Multi-Server WordPress Setup with Shared Users
  7. Change post status based on meta value
  8. Delete/replace img tags in post content for auto published posts [closed]
  9. Speed optimization of $wpdb->get_results
  10. What does wp_update_post() do that the $wpdb class does not?
  11. wpdb-> not adding prefix to custom table
  12. WordPress insert NOW() in TIMESTAMP column returns all zeros
  13. $wpdb prepare issue with mysql DATE_FORMAT
  14. How-To: wpdb Insert Record With Date
  15. How to pass NULL in where array for $wpdb->update
  16. Get random row from custom table
  17. store custom WP table names in a global variable
  18. I am not understandinhg $wpdb->prepare correctly
  19. How to save html and text in the database?
  20. XOR functionality for meta_query
  21. Using WPDB class
  22. How can I migrate mysql_fetch_array to $wbpdb?
  23. $wpdb->get_results returns empty but value exists
  24. What is _transient_random_seed for?
  25. wpdb get_results() and prepare when to use prepare?
  26. Foreach loop using $wpdb not results from rows
  27. Return XML of Post Metadata
  28. How to get a value-only flat array from $wpdb->get_results when selecting a single column, without foreach()?
  29. How do you build a wpdb query dynamically?
  30. Would this WPDB setup result in potential race conditions?
  31. How to update a row in a table in WordPress
  32. What’s the proper way to add users to my site in order to test things?
  33. Problem in inserting row to custom database table
  34. sanitize_text_field and apostrophe problem
  35. Codex: Database Description: meaning of Cardinality
  36. $wpdb->prepare with ON DUPLICATE KEY UPDATE
  37. Code only works every other time its run
  38. wpdb updating record in wordpress with json adds extra array elements
  39. How to display a specific category using a custom Query?
  40. Can’t pass variable in wordpress wpdb->get_results
  41. AWS Bitnami WordPress – SELECT command denied to user
  42. WPDB Placeholders and second argument for prepared statements
  43. PHP Fatal Error – $wpdb a non-object?
  44. How do I count columns on a custom WPDB query?
  45. Custom SQL query ORDER BY term_order
  46. Trouble inserting string containing quotations marks with wpdb in save_post hook
  47. How to run wp_insert_post() & wpdb on the background?
  48. $wpdb->prepare was called incorrectly when inserting multiple records
  49. How to protect a script execution on WordPress?
  50. Trying to get variable from WP table and toggle its value
  51. Set MySQL variables in WPDB
  52. How to prepare an array of values with $wpdb
  53. how to connect to another database in wordpress
  54. $wpdb->insert() doesnt work anymore
  55. $wpdb query outputs php code instead of executing it
  56. wpdb query not working
  57. Where can I see MySQL hostname and port for wp-config.php
  58. WordPress wpdb->insert returns int(0) => doesn’t insert anything, no errors!
  59. Perform a function when a user clicks register button
  60. $wpdb->get_results not returning an array
  61. query a newly created table using $wpdb
  62. WPDB Query Question with Category Only
  63. wpdb result arrray inside an array
  64. $wpdb->num_rows doesn’t work
  65. $wpdb->get_var next var?
  66. How can I change my meta_query to SQL wpdb query?
  67. How do I modify this wpdb query to include posts that have a post_status of publish and draft?
  68. Can’t find out why dbDelta dosen’t create my table
  69. How capturate wpdb exceptions?
  70. Limit left join
  71. Check if Value Exists in Database, adding row details to variables and echoing result
  72. wpdb discards duplicate column names?
  73. “This message was added in version X” showing a later version than current one
  74. Get records from Formidable Table using $wpdb->get_col
  75. WPDB SQL query SELECT from category
  76. How to get row value from wpdb
  77. I am using wpdb but it not working perfectly.but if I dont use form data its work
  78. How to Update multiple rows using $wpdb->update
  79. Unable to use $wpdb in WordPress
  80. How to display specific data from custom database table in WordPress
  81. Missing argument 2 for wpdb::prepare() [duplicate]
  82. Why is an empty result an error? ( $wpdb->get_row )
  83. get_row returns empty when data exists
  84. wpdb->update update the entire table instead of one row
  85. How to set up prepared query using IN statement
  86. Save customizer default values to DB on theme activation
  87. Plugin with connection to database – Single function
  88. Alter the main search query to search posts by coauthor user name
  89. WPDB Prepared Delete
  90. wpdb->update error
  91. wpdb Cannot Access Associative Array Data in a Count Query
  92. SQL Query to select post title & post ID from a particular category
  93. Using $wpdb to update current post
  94. Checking if meta_value exists for any user
  95. Can you create a new wpdb that connects to an SQL (not MYSQL) database? [duplicate]
  96. DBDelta: “table doesn’t exist” for a table that was just created
  97. query using wpdb in wordpress gets me no result
  98. query_vars doesn’t return query string (trying to get data from $wpdb)
  99. Table wont load into WPDB
  100. $wpdb->prepare UPDATE process not work in functions.php
error code: 523