hoffm11
Forum Replies Created
-
Forum: Plugins
In reply to: [dbview] Form pass value to DBViewOk, that would be useful. Appreciate it!
Forum: Plugins
In reply to: [dbview] Pagination Doesn't workYES! Works now! Thanks.
Forum: Plugins
In reply to: [dbview] Pagination Doesn't workodd.. 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
In reply to: [dbview] Pagination Doesn't workHi, 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
In reply to: [dbview] Pagination Doesn't workForum: Plugins
In reply to: [dbview] Pagination Doesn't workIs there a way for me to look at this log via WordPress? How?
Forum: Plugins
In reply to: [dbview] Pagination?I tried this [dbview name=’gamescores’ pagesize=10] and it still lists more than 10 records at a time.