hoffm11

Ok, that would be useful. Appreciate it!

YES! Works now! Thanks.

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;

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..

Nevermind, I got it.. https://www.csfastpitch.com/wp-admin/admin-ajax.php?action=dbview&verb=autoLoad&name=gamescores&pageSize=10

Is there a way for me to look at this log via WordPress? How?

I tried this [dbview name=’gamescores’ pagesize=10] and it still lists more than 10 records at a time.