[ad_1]
WPDA, PHP and MySql have issues with some special characters. I deal with it by avoiding anything except A-Z (both cases) and ‘_’ (underscore)
Try changing your select count(ID) to select count(ID) as count_ID
and your column in publication to count_ID
Many thanks for the reply Charles.
Unfortunately the Free version of the plugin doesn’t include Premium Data Publisher, so I am restricted to just being able to use the Publisher.
It sounds as though you can only select standard columns without any bells and whistles.
Actually I’ve just had a lightbulb moment thanks to working through your suggstion. I can create a View and then use the Publication to pick the value from there. Tried it and it worked.
Thanks again.
Awesome~ Thank you @charlesgodwin for pushing @quarlton in the right direction!
I’ll mark this thread as resolved now.
Feel free to create a new one if you have new questions. 🙂