Title: Display a single record
Last modified: September 1, 2016

---

# Display a single record

 *  Resolved [Louis Nel](https://wordpress.org/support/users/mrmin/)
 * (@mrmin)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/display-a-single-record/)
 * Hi there,
 * Please excuse the question if this has been answered before but cannot seem to
   find this in any of the documentation.
 * How do I output one record at a time using the _cdbt-view_ shortcode?
 * I only want to see 1 record at a time from the database table.
 * Great plugin by the way!
 * Thanks!
 * [https://wordpress.org/plugins/custom-database-tables/](https://wordpress.org/plugins/custom-database-tables/)

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

 *  [riori](https://wordpress.org/support/users/riori/)
 * (@riori)
 * [9 years, 9 months ago](https://wordpress.org/support/topic/display-a-single-record/#post-7587853)
 * i want to know this too
 *  Plugin Author [ka2](https://wordpress.org/support/users/ka2/)
 * (@ka2)
 * [9 years, 9 months ago](https://wordpress.org/support/topic/display-a-single-record/#post-7587870)
 * Thank you for your inquiry.
 * In the “cdbt-view” shortcode options, you should set 1 to “Max Rows Per Page”.
   However, if that table has multiple row (record), it’s displayed the pager or
   the pagination. If you want to show an unique row only, you should narrow down
   optimal data by using “Narrow-down Keywords” option.
 * Also, example of shortcode is as follows:
 *     ```
       [cdbt-view table="your_table_name" limit_items="1"]
       ```
   
 *     ```
       [cdbt-view table="your_table_name" narrow_keyword="ID:2" limit_items="1"]
       ```
   
 * Thank you,
 *  Thread Starter [Louis Nel](https://wordpress.org/support/users/mrmin/)
 * (@mrmin)
 * [9 years, 9 months ago](https://wordpress.org/support/topic/display-a-single-record/#post-7587872)
 * Thanks for the solution!

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

The topic ‘Display a single record’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/custom-database-tables_e4e2e2.svg)
 * [Custom DataBase Tables](https://wordpress.org/plugins/custom-database-tables/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/custom-database-tables/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/custom-database-tables/)
 * [Active Topics](https://wordpress.org/support/plugin/custom-database-tables/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/custom-database-tables/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/custom-database-tables/reviews/)

 * 3 replies
 * 3 participants
 * Last reply from: [Louis Nel](https://wordpress.org/support/users/mrmin/)
 * Last activity: [9 years, 9 months ago](https://wordpress.org/support/topic/display-a-single-record/#post-7587872)
 * Status: resolved