If you put variables inside a string, you have to use " double quotes.
So:
// This:
$qstr="
SELECT *
...
ORDER BY $wpdb->posts.post_date DESC
";
// becomes...
$qstr = "
SELECT *
...
ORDER BY $wpdb->posts.post_date DESC
";
Related Posts:
- convert it into short code & explan how? [closed]
- Enqueue Scripts / Styles when shortcode is present
- Conditionally Loading JavaScript/CSS for Shortcodes
- What does extract( shortcode_atts( array( do?
- How do I escape a ‘]’ in a short code?
- Pass boolean value in shortcode
- Show shortcode without executing it
- Shortcode always displaying at the top of the page
- Redirect function inside a Shortcode
- How to create a shortcode with 1 parameter (atts)
- how to show the syntax of a shortcode
- Custom shortcode being executed when saving page in wp-admin
- Change appearance of shortcode text inside editor
- current_shortcode() – detect currently used shortcode
- shortcodes output before content [duplicate]
- WordPress plugin shortcode not working
- How to add stylesheets only to pages with specific shortcode?
- Using get_option() in JavaScript
- Shortcode empty attribute
- How does a shortcode work?
- Shortcode outputs at the top of the_content
- the_excerpt and shortcodes
- Using wp_editor in shortcode
- Remove wpautop from shortcode content / remove whitespace in buffering
- Get current post id witout passing in shortcode
- Why are you using add_action for shortcode?
- How to get URL param to shortcode?
- How to add multiple buttons to TinyMCE?
- Check if post/page has gallery?
- Get first video from the post (both embed and video shortcodes)
- Get shortcode name from within it’s callback function? [duplicate]
- Wordspress add into my javascripts
- Making a Shortcode [NEXT] and [PREVIOUS] to place into specific posts for post navigation
- How do I create a Shortcode that returns text if domain is .com, not .co.uk
- Using preg_replace to separate gallery from the_content?
- Remove specific shortcode from get_the_content()
- How to display the site name in a WordPress page, or post
- Hide/show content starting in the middle of a paragraph
- Combining shortcode and get_template_part
- How can I put a wp_redirect into a shortcode?
- Escaping quotes from shortcode attributes
- Run visual composer code in php page
- short code output too early
- Shortcode in shortcode: How to append variable?
- Remove wptexturize from a shortcode?
- How can i put an array as variable in shortcode_atts?
- Autoembeds don’t work with paragraphs
- Table of Contents with a shortcode
- Create custom [sourcecode] shortcode, the right way?
- TED talks shortcode not working
- Allowing shortcodes inside attributes
- What is the best way to enable nested shortcodes?
- Tinymce – How to hook before or after live shortcodes rendering?
- How to customize a shortcode using the customizer
- Native “playlist” shortcode random playing… How?
- How to Output HTML tags in do_shortcode?
- List of all inbuilt WordPress shortcodes
- Nested Shortcode Detection
- Shortcode output always showing at top of page
- Organizing shortcodes. How to display all of them and their attributes?
- How to detect if a Shortcode is being called on a page?
- How to get current page title inside a page itself in a shortcode and in page content
- how to have the gallery shortcode output one single UL list instead of several DL?
- Implement If-ElseIf-Else-EndIf with short codes
- Short code to display a loop
- Using shortcode in Post title
- using html as shortcode attribute
- shortcode outputs first before the page content [duplicate]
- How to add ‘class’ attribute into shortcode [audio]?
- Make shortcode work with nested double quotes
- Get all posts containing a shortcode
- How to display the names of users from a specific group with a shortcode?
- WordPress adds br in between my shortcode
- Stray closing paragraph tag when using shortcodes
- How to display html in a shortcode
- Can I strip HTML tags in the “Compare Revisions” screen?
- Custom form, shortcode, and submit handler
- shortcode inside another shortcode
- Automatically add this attribute to the gallery shortcode
- WordPress transients for a shortcode
- Are php template shortcodes ok?
- Extract attribute values from every shortcode in post
- How to make shortcode to hide selection of text from post or page?
- Get post id shortcode
- how to get shortcodes to work inside the text of custom fields
- Shortcode attribute value with dash (hyphen)
- Set wmode attribute to transparent for the embed shortcode to make drop-down menu hover over YouTube embed in Internet Explorer
- Using action hooks inside of a shortcode
- How can I just get content inside a shortcode or just outside
- how do you get the author’s username?
- do_shortcode inside AJAX callback
- shortcode for logo image
- Stop strip_shortcodes() stripping content inside shortcodes
- shortcode_unautop shortcode not functioning
- Videos via the video shortcode are always 640px wide?
- Shortcode perfomance solution
- Shortcodes, HTML tables, and multiple rows
- Need MySQL Query or WP-CLI command to updates old URLs in Shortcodes [closed]
- Video embeds work in backend, but are not parsed in frontend
- How to handle valueless attributes in shortcodes?