Title: Query Button? Last modified: August 21, 2016 --- # Query Button? * [jetwashphotos](https://wordpress.org/support/users/jetwashphotos/) * (@jetwashphotos) * [12 years, 3 months ago](https://wordpress.org/support/topic/query-button/) * Hello, I 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: * Button Name would be “Update Sightings Makes” UPDATE AVDMASTER p, SightingsEntrytmp pp SET pp.MAKE = ‘1’ WHERE pp.UNIQUEID = p.UNIQUEID AND p.MAKE = ‘0’; * Thanks, * Stephen * [https://wordpress.org/plugins/abase/](https://wordpress.org/plugins/abase/) Viewing 2 replies - 1 through 2 (of 2 total) * [rzharding](https://wordpress.org/support/users/rzharding/) * (@rzharding) * [12 years, 3 months ago](https://wordpress.org/support/topic/query-button/#post-4587747) * Stephen * You could use text links and style them with borders. * See example below. Do a web search on “**style links css**“ * Given that you have many links, you could consider the options in the following Sitepoint article to use lists as a navigation tool. * I think it is easier than using buttons. * [http://www.sitepoint.com/build-site-navigation-css/](http://www.sitepoint.com/build-site-navigation-css/) * The page that the link references would have the abase shortcode. * [abase sql=”UPDATE AVDMASTER p, SightingsEntrytmp pp SET pp.MAKE = ‘1’ WHERE pp.UNIQUEID = p.UNIQUEID AND p.MAKE = ‘0’”] * ——————————————— Text Link

[Text Link](https://wordpress.org/support/topic/query-button/?output_format=md#)

* Richard Harding * Thread Starter [jetwashphotos](https://wordpress.org/support/users/jetwashphotos/) * (@jetwashphotos) * [12 years, 2 months ago](https://wordpress.org/support/topic/query-button/#post-4587842) * Hey Richard, * Thanks. I have done a little work around, by placing the sql queries on individual pages for now. Click on the page link and the query runs. * Followup question for you though. Do you know if Abase runs queries concurrently or in sequence? For example, if I place two sql queries on a page, would it run the them in order of placement: * [abase sql=”UPDATE AVDMASTER p, SightingsEntrytmp pp SET pp.MAKE = ‘1’ WHERE pp.UNIQUEID = p.UNIQUEID AND p.MAKE = ‘0’;”] * [abase sql=”UPDATE SightingsEntrytmp p, AVDMASTER pp SET pp.MAKE = ‘1’ WHERE pp.UNIQUEID = p.UNIQUEID AND p.MAKE = ‘1’;”] * I need to first query to be complete in order to run the second query. * Thanks, * Stephen Viewing 2 replies - 1 through 2 (of 2 total) The topic ‘Query Button?’ is closed to new replies. * ![](https://s.w.org/plugins/geopattern-icon/abase.svg) * [ABASE](https://wordpress.org/plugins/abase/) * [Frequently Asked Questions](https://wordpress.org/plugins/abase/#faq) * [Support Threads](https://wordpress.org/support/plugin/abase/) * [Active Topics](https://wordpress.org/support/plugin/abase/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/abase/unresolved/) * [Reviews](https://wordpress.org/support/plugin/abase/reviews/) ## Tags * [button](https://wordpress.org/support/topic-tag/button/) * [query](https://wordpress.org/support/topic-tag/query/) * [sql](https://wordpress.org/support/topic-tag/sql/) * 2 replies * 2 participants * Last reply from: [jetwashphotos](https://wordpress.org/support/users/jetwashphotos/) * Last activity: [12 years, 2 months ago](https://wordpress.org/support/topic/query-button/#post-4587842) * Status: not resolved