Title: hoffm11's Replies | WordPress.org

---

# hoffm11

  [  ](https://wordpress.org/support/users/hoffm11/)

 *   [Profile](https://wordpress.org/support/users/hoffm11/)
 *   [Topics Started](https://wordpress.org/support/users/hoffm11/topics/)
 *   [Replies Created](https://wordpress.org/support/users/hoffm11/replies/)
 *   [Reviews Written](https://wordpress.org/support/users/hoffm11/reviews/)
 *   [Topics Replied To](https://wordpress.org/support/users/hoffm11/replied-to/)
 *   [Engagements](https://wordpress.org/support/users/hoffm11/engagements/)
 *   [Favorites](https://wordpress.org/support/users/hoffm11/favorites/)

 Search replies:

## Forum Replies Created

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

 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[dbview] Form pass value to DBView](https://wordpress.org/support/topic/form-pass-value-to-dbview/)
 *  Thread Starter [hoffm11](https://wordpress.org/support/users/hoffm11/)
 * (@hoffm11)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/form-pass-value-to-dbview/#post-7222851)
 * Ok, that would be useful. Appreciate it!
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[dbview] Pagination Doesn't work](https://wordpress.org/support/topic/pagination-doesnt-work-11/)
 *  Thread Starter [hoffm11](https://wordpress.org/support/users/hoffm11/)
 * (@hoffm11)
 * [12 years, 3 months ago](https://wordpress.org/support/topic/pagination-doesnt-work-11/#post-4884209)
 * YES! Works now! Thanks.
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[dbview] Pagination Doesn't work](https://wordpress.org/support/topic/pagination-doesnt-work-11/)
 *  Thread Starter [hoffm11](https://wordpress.org/support/users/hoffm11/)
 * (@hoffm11)
 * [12 years, 3 months ago](https://wordpress.org/support/topic/pagination-doesnt-work-11/#post-4884205)
 * odd.. So I removed the limit and when I try to execute it, I get
 * You have an error in your SQL syntax; check the manual that corresponds to your
   MySQL server version for the right syntax to use near ‘LIMIT 20 OFFSET 0’ at 
   line 1
 * SELECT division, month, day, year, gamecode, hometeam, homescore, visitteam, 
   visitscore FROM game_scores where homescore > 0 or visitscore >0 and year = 2014
   order by month DESC, day DESC;
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[dbview] Pagination Doesn't work](https://wordpress.org/support/topic/pagination-doesnt-work-11/)
 *  Thread Starter [hoffm11](https://wordpress.org/support/users/hoffm11/)
 * (@hoffm11)
 * [12 years, 3 months ago](https://wordpress.org/support/topic/pagination-doesnt-work-11/#post-4884202)
 * Hi, I did look at those samples and the paging does work. Here is my SQL:
 * SELECT division, month, day, year, gamecode, hometeam, homescore, visitteam, 
   visitscore FROM game_scores where homescore > 0 or visitscore >0 and year = 2014
   order by month DESC, day DESC LIMIT 20;
 * I don’t see the offset and limit on the SQL query for the show all options. That
   is probably where I am confused..
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[dbview] Pagination Doesn't work](https://wordpress.org/support/topic/pagination-doesnt-work-11/)
 *  Thread Starter [hoffm11](https://wordpress.org/support/users/hoffm11/)
 * (@hoffm11)
 * [12 years, 3 months ago](https://wordpress.org/support/topic/pagination-doesnt-work-11/#post-4884045)
 * Nevermind, I got it.. [http://www.csfastpitch.com/wp-admin/admin-ajax.php?action=dbview&verb=autoLoad&name=gamescores&pageSize=10](http://www.csfastpitch.com/wp-admin/admin-ajax.php?action=dbview&verb=autoLoad&name=gamescores&pageSize=10)
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[dbview] Pagination Doesn't work](https://wordpress.org/support/topic/pagination-doesnt-work-11/)
 *  Thread Starter [hoffm11](https://wordpress.org/support/users/hoffm11/)
 * (@hoffm11)
 * [12 years, 3 months ago](https://wordpress.org/support/topic/pagination-doesnt-work-11/#post-4884041)
 * Is there a way for me to look at this log via WordPress? How?
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[dbview] Pagination?](https://wordpress.org/support/topic/pagination-108/)
 *  [hoffm11](https://wordpress.org/support/users/hoffm11/)
 * (@hoffm11)
 * [12 years, 3 months ago](https://wordpress.org/support/topic/pagination-108/#post-4523156)
 * I tried this [dbview name=’gamescores’ pagesize=10] and it still lists more than
   10 records at a time.

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