Title: Hidden/Appearing Query Rows
Last modified: August 21, 2016

---

# Hidden/Appearing Query Rows

 *  [jstevenot](https://wordpress.org/support/users/jstevenot/)
 * (@jstevenot)
 * [12 years, 6 months ago](https://wordpress.org/support/topic/hiddenappearing-query-rows/)
 * I was wondering if there was a way to take the table and hide it until someone
   did a query/search?
 * I have a data set that is quite large and it would be easier if the information
   just “appeared” on the screen after the user put in their searchable information.
 * Thanks.
 * [http://wordpress.org/plugins/abase/](http://wordpress.org/plugins/abase/)

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

 *  [rollbrettfahrer77](https://wordpress.org/support/users/rollbrettfahrer77/)
 * (@rollbrettfahrer77)
 * [12 years, 5 months ago](https://wordpress.org/support/topic/hiddenappearing-query-rows/#post-4316110)
 * You could output the results on an extra page by adding an url parameter in form
   =”…”
 *     ```
       [abase form="1,search,/results" table="employees" columns="first_name,last_name$Search Employees" elements="first_name,last_name"]
       ```
   
 * then on the /results page
 * `[abase table="employees" columns="first_name,last_name" ack="green"]`
 * BUT the whole data set would still be viewable to the clever user when he goes
   directly to /results.
 * Any ideas for a better solution?
 *  [rollbrettfahrer77](https://wordpress.org/support/users/rollbrettfahrer77/)
 * (@rollbrettfahrer77)
 * [12 years, 4 months ago](https://wordpress.org/support/topic/hiddenappearing-query-rows/#post-4316131)
 * Kind of solved this by adding limit=”1″ on the results page.
 *  [BioteconDiagnostics](https://wordpress.org/support/users/biotecondiagnostics/)
 * (@biotecondiagnostics)
 * [12 years, 3 months ago](https://wordpress.org/support/topic/hiddenappearing-query-rows/#post-4316139)
 * I found a solution.
    In mySQL I created 3 columns: ID, product and URL
 * ID Product Url
    1 let it empty let it empty 2 Product-1 URL-1 3 Product-2 URL-
   2 4 Product-3 URL-3 5 Product-4 URL-4
 * If you would write limit=”1″, then it would be the list preview empty.
 * [abase table=”TABLE” columns=”url” alink=”url,../../product/,url,’_blank'” notitle
   =”1″ limit=”1″]
 *  [jetwashphotos](https://wordpress.org/support/users/jetwashphotos/)
 * (@jetwashphotos)
 * [12 years, 3 months ago](https://wordpress.org/support/topic/hiddenappearing-query-rows/#post-4316141)
 * Hello,
 * Newbie to Abase, some sql experience. I have a similar question. I would like
   the search box to appear on page opening, but the table preview is taking too
   long. I have 70,000+ rows in this table. Here is my current ABASE query:
 * [abase form=”1,search” table=”AIRLOG” columns=”OPERATOR,REG$Search AIRLOG” elements
   =”OPERATOR,REG”]
 * [abase table=”AIRLOG” columns=”OPERATOR,REG,FULLTYPE,MSN,AIR,DATE,NOTES,EVENT,
   FLIGHT,MAKE” ack=”green”]
 * I have 1 million+ in another table, so I would really like some assistance.
 *  [rzharding](https://wordpress.org/support/users/rzharding/)
 * (@rzharding)
 * [12 years, 3 months ago](https://wordpress.org/support/topic/hiddenappearing-query-rows/#post-4316145)
 * Try something like:
 * [abase form=”1,search, [http://XXXXX/testing-2&#8243](http://XXXXX/testing-2&#8243);
   table=”AIRLOG” columns=”OPERATOR,REG$Search AIRLOG” elements=”OPERATOR,REG”]
 * On another page **testing-2**, place
 * [abase table=”AIRLOG” columns=”OPERATOR,REG,FULLTYPE,MSN,AIR,DATE,NOTES,EVENT,
   FLIGHT,MAKE” ack=”green”]
 * Richard Harding
 *  [jetwashphotos](https://wordpress.org/support/users/jetwashphotos/)
 * (@jetwashphotos)
 * [12 years, 3 months ago](https://wordpress.org/support/topic/hiddenappearing-query-rows/#post-4316146)
 * Hello Richard,
 * That is perfect. Thanks. What I have done is place: [abase form=”1,search, [http://XXXXX/testing-2&#8243](http://XXXXX/testing-2&#8243);
   table=”AIRLOG” columns=”OPERATOR,REG$Search AIRLOG” elements=”OPERATOR,REG”] 
   on the testing
 * and on testing-2, I have place both shortcodes [abase form=”1,search, [http://XXXXX/testing-2&#8243](http://XXXXX/testing-2&#8243);
   table=”AIRLOG” columns=”OPERATOR,REG$Search AIRLOG” elements=”OPERATOR,REG”]
 * and [abase table=”AIRLOG” columns=”OPERATOR,REG,FULLTYPE,MSN,AIR,DATE,NOTES,EVENT,
   FLIGHT,MAKE” ack=”green”]
 * This way the search form is always available. No going back and forth.
 * Thanks again,
 * Stephen
 *  [rzharding](https://wordpress.org/support/users/rzharding/)
 * (@rzharding)
 * [12 years, 3 months ago](https://wordpress.org/support/topic/hiddenappearing-query-rows/#post-4316147)
 * Wonderful – and it is a great idea to place the search form on the second page.
   It makes it easier to use.
 * Richard

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

The topic ‘Hidden/Appearing Query Rows’ 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/)

 * 7 replies
 * 5 participants
 * Last reply from: [rzharding](https://wordpress.org/support/users/rzharding/)
 * Last activity: [12 years, 3 months ago](https://wordpress.org/support/topic/hiddenappearing-query-rows/#post-4316147)
 * Status: not resolved