This plugin allows you to create reports simply by entering in the SQL.
Start Creating and Saving Reports.
Just use the shortcode SQLREPORT like this [SQLREPORT name="My Report" style="border: 2px solid #CCCCCC; padding: 6px;" /] but be sure the name attribute matches the exact name of a report you have already created.
SELECT display_name FROM wp_users WHERE ID = 'ID ?>' (I know there are other ways to get the display name in WordPress, this is just a simple example to illustrate the proper syntax.)
SELECT * FROM wp_users WHERE user_registered > '' (note: this example assumes you are going to pass 'thedate' as a GET variable in the query string and, as this example shows, don't use quotes inside the PHP brackets.)
Requires: 2.6 or higher
Compatible up to: 3.5.1
Last Updated: 2013-3-25
4 of 4 support threads in the last two months have been resolved.
Got something to say? Need help?