Support » Plugin: Inline Google Spreadsheet Viewer » MYSQL wpdb filtering

  • Resolved al9000nj

    (@al9000nj)


    Is there any syntax to follow in the WHERE clause if you want to filter by say USER.ID, some plugins use {user.id} which I think is how it is represented. I got it to work with a simple WHERE field so and so = value, but {user.id} does not work.

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

    (@meitar)

    Just use SQL. users is not a table in your database so of course it would not work. It might be wp_users but it depends on your WordPress configuration for the database table prefix. Don’t use WordPress-isms when querying a MySQL table with this plugin, just use regular SQL, like the documentation for the query attribute tells you to.

Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.