Plugin Author
Eli
(@scheeeli)
Sorry for the delay in getting back to you. I don’t think you can run shortcodes in a text widget.
However, I just released a new version of my SQL Reports plugin which include a Reports Widget. Please upgrade and give it a try, and let me know how it works for you,
Aloha, Eli
Many thanks, that’s great. One extra query.. In the change log there is a mention of using multiple sql queries in a report. What exactly does that mean? Could you give a simple example?
Regards,
Rob
Plugin Author
Eli
(@scheeeli)
The multiple query feature was designed to solve the Problem of executing a SET statement prior to your SELECT statement, like this:
SET @myname = ‘Eli’;
SELECT @myname;
When including multiple queries in your SQL Report only the last statement will be returned. So you could also use it as a sort of counter, like this:
INSERT INTO wp_options (option_name, option_value) VALUES (‘Eli_Test_Counter’, ‘1’) ON DUPLICATE KEY UPDATE option_value=option_value+1;
SELECT option_value FROM wp_options WHERE option_name = ‘Eli_Test_Counter’;
