Title: SQL
Last modified: November 28, 2021

---

# SQL

 *  Resolved [pocketpete](https://wordpress.org/support/users/pocketpete/)
 * (@pocketpete)
 * [4 years, 6 months ago](https://wordpress.org/support/topic/sql-7/)
 * I have been playing around with the plugin as a free user for some time and I
   think it will be able to handle my project.
 * I am happy I can create the tables I require and set up all the linked tables
   using the system but the data publisher is very limited in the free version.
 * I have a SQL query
    SELECT Player_Name, GROUP_CONCAT(Player_Break ORDER BY Player_Break
   DESC) FROM Player_Breaks GROUP BY Player_Name
 * Which works fine in the query builder and show the results as I wanted them. 
   What I want to do i publish these results to a wordpress post. I cannot seem 
   to find anywhere I can do this in the free version.
    I presume this can be done
   under widgets or data publisher in the premium version.
 * Can you confirm this is the case that once I purchase I will be able to display
   data produced by the SQL onto a post for users to view. The idea being that I
   can update the database tables once sports results are sent to me and the changes
   will be live on the website. Obviously I can do this via a csv import but that
   means an extra stage.

Viewing 7 replies - 1 through 7 (of 7 total)

 *  [charles godwin](https://wordpress.org/support/users/charlesgodwin/)
 * (@charlesgodwin)
 * [4 years, 6 months ago](https://wordpress.org/support/topic/sql-7/#post-15111368)
 * You could create a view of this SQL and then publish that. I do that all the 
   time.
 *     ```
       create view <view_name> as 
       SELECT Player_Name,
       GROUP_CONCAT(Player_Break ORDER BY Player_Break DESC)
       FROM Player_Breaks
       GROUP BY Player_Name;
       ```
   
    -  This reply was modified 4 years, 6 months ago by [charles godwin](https://wordpress.org/support/users/charlesgodwin/).
 *  Thread Starter [pocketpete](https://wordpress.org/support/users/pocketpete/)
 * (@pocketpete)
 * [4 years, 6 months ago](https://wordpress.org/support/topic/sql-7/#post-15111396)
 * Is that within wpdata tables? or as a separate view with the database?
    -  This reply was modified 4 years, 6 months ago by [pocketpete](https://wordpress.org/support/users/pocketpete/).
 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [4 years, 6 months ago](https://wordpress.org/support/topic/sql-7/#post-15113592)
 * Hi [@pocketpete](https://wordpress.org/support/users/pocketpete/),
 * You can use the Query Builder to interactively enter your create view statement
   or save your create view statement in a script file and execute it from the Data
   Explorer.
 * Does this help?
    Peter
 *  Thread Starter [pocketpete](https://wordpress.org/support/users/pocketpete/)
 * (@pocketpete)
 * [4 years, 6 months ago](https://wordpress.org/support/topic/sql-7/#post-15115362)
 * The sql works fine in the query builder but you cannot save the query in the 
   version I have downloaded when you hover over ‘save’ you get JavaScript void 
   appearing at the bottom of the screen. if i have to create a view its another
   step in the process which i am trying to avoid.
 * I thought the program would allow you to display a table based upon a sql search
 * Creating a view has sorted it. Many thanks
 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [4 years, 6 months ago](https://wordpress.org/support/topic/sql-7/#post-15115485)
 * Hi [@pocketpete](https://wordpress.org/support/users/pocketpete/),
 * You should be able to save a query in the free version. Can you please try? Just
   save the query (don’t pay attention to the void message), reload the page and
   try to reload the SQL script.
 * Please let me know if this works? Can you share a screenshot if it doesn’t work?
 * Thanks,
    Peter
 *  Thread Starter [pocketpete](https://wordpress.org/support/users/pocketpete/)
 * (@pocketpete)
 * [4 years, 6 months ago](https://wordpress.org/support/topic/sql-7/#post-15115571)
 * Yes you click the button but its not saving. It seems to ‘click’ then you see
   the java script(0) bottom left. It’s not a major problem as I will be ordering
   the full version in the next week.
    I’ve finally sorted all those little problems.
   I wanted to use vb6 to create an odbc remote connection to wordpress. Took me
   best part of a week to get the connection settings working. Was using the 64bit
   odbc instead of 32. Damn. But now I can use it to enter the data straight into
   the tables in wordpress. Wpdata access can handle all the displaying of the data
   and some minor querys that can’t be done remotely so looking good. Just I had
   time to learn php.
 *  Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/)
 * (@sterndata)
 * Volunteer Forum Moderator
 * [4 years, 6 months ago](https://wordpress.org/support/topic/sql-7/#post-15117896)
 * [@peterschulznl](https://wordpress.org/support/users/peterschulznl/) I’ve deleted
   your offer to login to your user’s site. I’m am 100% sure you mean well but please
   _never ask for credentials on these forums._
 * [https://wordpress.org/support/guidelines/#the-bad-stuff](https://wordpress.org/support/guidelines/#the-bad-stuff)
 * Now for the why: The internet is a wonderful place full of very nice people and
   a few very bad ones. I’m sure everyone here is very nice however, by giving some
   ones keys to your house you are trusting they wont steal anything. Likewise the
   person who takes the keys is now responsible for the house FOREVER.
 * If something was to go wrong, then you the author may well legally become liable
   for damages, which they would not normally have been as their software is provided
   without warranty.
 * **Please be aware that repeatedly asking for credentials will result in us escalating
   this to the plugins team.**
 * It’s never necessary to do that. Here’s why.
 * There are many ways to get information you need and accessing the user’s site
   is not one of them. That’s going too far.
    - Ask for a link to the [http://pastebin.com/](http://pastebin.com/) log of 
      the user’s web server error log.
    - Ask the user to create and post a link to their `phpinfo();` output.
    - Ask the user to install the [Health Check plugin](https://wordpress.org/support/plugin/health-check/)
      and get the data that way.
    - Walk the user through [enabling WP_DEBUG and how to log that output to a file and how to share that file.](https://codex.wordpress.org/WP_DEBUG#WP_DEBUG_LOG_and_WP_DEBUG_DISPLAY)
    - Walk the user through basic troubleshooting steps such and disabling all other
      plugins, clear their cache and cookies and try again.
    - Ask the user for the step-by-step on how they can reproduce the problem.
 * You get the idea.
 * Volunteer support is not easy. But these forums need to a safe place for all 
   users, experienced or new. Accessing their system that way is a short cut that
   will get you into real trouble in these forums.

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘SQL’ is closed to new replies.

 * ![](https://ps.w.org/wp-data-access/assets/icon-256x256.png?rev=3299063)
 * [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards](https://wordpress.org/plugins/wp-data-access/)
 * [Support Threads](https://wordpress.org/support/plugin/wp-data-access/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-data-access/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-data-access/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-data-access/reviews/)

 * 7 replies
 * 4 participants
 * Last reply from: [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/)
 * Last activity: [4 years, 6 months ago](https://wordpress.org/support/topic/sql-7/#post-15117896)
 * Status: resolved