Title: sqlgetvar does not return result – the return !
Last modified: October 29, 2016
---
# sqlgetvar does not return result – the return !
* Resolved [chab0tais](https://wordpress.org/support/users/chab0tais/)
* (@chab0tais)
* [9 years, 7 months ago](https://wordpress.org/support/topic/sqlgetvar-does-not-return-result-the-return/)
* Hello Eli,
* Thank you for your smart plugin, it is great.
* Unfortunately, I got the same problem you answer 7 month ago. I have read your
answer and tried to impplement it :
* > I think I found out why you are having this problem. WordPress automatically
> changes your content and replaces your single quotes with something they call
> smart quotes 🙁
> You will need to remove the filter for the wptexturize function before this
> shortcode will work with quotes in it. You’ll need to add this line of code
> to a PHP file where it can run in the init action hook:
> remove_filter (‘the_content’,‘
> wptexturize’);
> If you can’t find a better place to put this code you can add it to my plugin
> inside the ELISQLREPORTS_init function on line 899 of elisqlreports/trunk/index.
> php
* The problem is clearly that : if I use a query with quote or double quote, sqlgetvar
do not answer anything.
But unfortunately, your suggestion to add remove_filter
in index.php of your pluging, do not change anything…
* Do you have any other solution ? Or do you intend to implement a solution in
your pluging, by changing back any character modification made by WP in sqlgetvar?
Last thing : I use WP 4.6.1 with theme twenty fourteen.
* Thanks for your answer.
Viewing 11 replies - 1 through 11 (of 11 total)
* Plugin Author [Eli](https://wordpress.org/support/users/scheeeli/)
* (@scheeeli)
* [9 years, 7 months ago](https://wordpress.org/support/topic/sqlgetvar-does-not-return-result-the-return/#post-8372389)
* I won’t ever put that particular fix in my plugin release because it’s only needed
for a few users who have that problem and it’s a personalization that wouldn’t
be right to inflict on everyone else who may not want the “smart quotes” feature
disabled.
* I’m not sure why it’s not working for you though. maybe you have a different
issue like unescaped quotes within your quotes. Can you post your shortcode so
I can see what else might be wrong.
* Thread Starter [chab0tais](https://wordpress.org/support/users/chab0tais/)
* (@chab0tais)
* [9 years, 7 months ago](https://wordpress.org/support/topic/sqlgetvar-does-not-return-result-the-return/#post-8372585)
* Here it is:
* > Nombre d’inscrits actuel : [sqlgetvar]SELECT COUNT(*) FROM `mod182_cb_frontend_data_table`
> where form_id=2 and dynamic_control_id=6[/sqlgetvar]/150
> Open A : [sqlgetvar]
> SELECT COUNT(*) FROM `mod182_cb_frontend_data_table`
> WHERE form_id=2 AND dynamic_frontend_value LIKE ‘%A%’ [/sqlgetvar] Open B :[
> sqlgetvar] SELECT COUNT(*) FROM `mod182_cb_frontend_data_table` WHERE form_id
> =2 AND dynamic_frontend_value LIKE “%B%” [/sqlgetvar]
* This code displays:
* > Nombre d’inscrits actuel : 1/150
> Open A :
> Open B :
* The first query is working properly.
The second and the third are not working
with sqlgetvar, and they work fine on phpmyadmin. I tried also the syntax:
* > dynamic_frontend_value=”Open B”
* or
* > dynamic_frontend_value LIKE “Open B”
* that works on phpmyadmin, but not with sqlgetvar.
If I suppress:
* > AND dynamic_frontend_value LIKE ‘%A%’
* sqlgetvar returns a value (that is not what I want tot do, but that shows the
problem comes probably from the incorrect encoding of quotes characters by WP).
- This reply was modified 9 years, 7 months ago by [chab0tais](https://wordpress.org/support/users/chab0tais/).
- This reply was modified 9 years, 7 months ago by [chab0tais](https://wordpress.org/support/users/chab0tais/).
- This reply was modified 9 years, 7 months ago by [chab0tais](https://wordpress.org/support/users/chab0tais/).
* Thread Starter [chab0tais](https://wordpress.org/support/users/chab0tais/)
* (@chab0tais)
* [9 years, 7 months ago](https://wordpress.org/support/topic/sqlgetvar-does-not-return-result-the-return/#post-8372606)
* A last think : if I create a report qith the same query, it works properly. But
I can’t insert the result into a text paragraph with [SQLREPORT name=”nbinscritsopena”]
* Plugin Author [Eli](https://wordpress.org/support/users/scheeeli/)
* (@scheeeli)
* [9 years, 7 months ago](https://wordpress.org/support/topic/sqlgetvar-does-not-return-result-the-return/#post-8378241)
* Yes, I see, it doesn’t sound like my original hack worked for you. Where did
you put that code I had posted?
`remove_filter ('the_content', 'wptexturize');`
* Maybe it not in the right place so it is not affecting the filter. Also maybe
there is another why you could encode those quotes, like using the HTML codes
for single and double quotes or something.
* Thread Starter [chab0tais](https://wordpress.org/support/users/chab0tais/)
* (@chab0tais)
* [9 years, 7 months ago](https://wordpress.org/support/topic/sqlgetvar-does-not-return-result-the-return/#post-8383000)
* I wrote it here :
* > function ELISQLREPORTS_init() {
> remove_filter (‘the_content’, ‘wptexturize’);
> if (isset($GLOBALS[“ELISQLREPORTS”][“reports_array”]) && is_array($GLOBALS[“
> ELISQLREPORTS”][“reports_array”])) { $Report_Number = 0; if (isset($GLOBALS[“
> ELISQLREPORTS”][“settings_array”][“menu_sort”]) && $GLOBALS[“ELISQLREPORTS”][“
> settings_array”][“menu_sort”])
* [khunglarsen](https://wordpress.org/support/users/khunglarsen/)
* (@khunglarsen)
* [9 years, 6 months ago](https://wordpress.org/support/topic/sqlgetvar-does-not-return-result-the-return/#post-8431124)
* /*
I was having the same problem, I resolved this by using the tag
this will override the wptexturize function..
* Text enclosed in the tags
* ```
, `, ,