{"id":4587558,"date":"2014-02-07T13:15:35","date_gmt":"2014-02-07T13:15:35","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/query-button\/"},"modified":"2016-08-21T16:03:47","modified_gmt":"2016-08-21T16:03:47","slug":"query-button","status":"closed","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/query-button\/","title":{"rendered":"Query Button?"},"content":{"rendered":"<p>Hello,<br \/>\nI would like to learn how to create a submit button that runs a SQL query. I have many to create, but here is an example of one:<\/p>\n<p>Button Name would be &#8220;Update Sightings Makes&#8221;<br \/>\nUPDATE AVDMASTER p, SightingsEntrytmp pp<br \/>\nSET pp.MAKE = &#8216;1&#8217;<br \/>\nWHERE pp.UNIQUEID = p.UNIQUEID AND p.MAKE = &#8216;0&#8217;;<\/p>\n<p>Thanks,<\/p>\n<p>Stephen<\/p>\n<p>https:\/\/wordpress.org\/plugins\/abase\/<\/p>\n","protected":false},"template":"","class_list":["post-4587558","topic","type-topic","status-closed","hentry","topic-tag-button","topic-tag-query","topic-tag-sql"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/4587558","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/4587558\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=4587558"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}