Support » Plugin: EZ SQL Reports Shortcode Widget and DB Backup » Need a plain text output instead of table format

  • Resolved cihat74

    (@cihat74)


    Hi,

    Thanks for your effort.

    I need to build a one line sentence showing the result like this:

    This month’s winner is: [SQLREPORT name=”rekor-kimde”]

    * Report results the name of the person.

    I managed to hide the headings of the report and query result but since it is in table format, name of the person goes below. I tried sqlgetvar but it gives error. Or maybe it is used to show totals only.

    https://wordpress.org/plugins/elisqlreports/

Viewing 1 replies (of 1 total)
  • Plugin Author Eli

    (@scheeeli)

    Since you have already hidden the title you could just change your query so that all the column data if outup inside a single column with the text concatenated in with it, like this:

    SELECT CONCAT(‘There are currently over ‘, COUNT(DISTINCT user_id),’ Registered Users on this site.’) as Current Registrations
    FROM wp_usermeta
    WHERE…

    or you could use the sqlgetvar shortcode, like this:
    [sqlgetvar]SELECT COUNT(*) FROM wp_users[/sqlgetvar]

Viewing 1 replies (of 1 total)
  • The topic ‘Need a plain text output instead of table format’ is closed to new replies.