Help with report builder
Hi, I am probably missing something really basic. I have created a report, but the screen is blank.
I have a table called registration_forms, with a checkbox field called facebookmarketing. I would like my report to display all records where facebookmarketing is checked.
SELECT title FROM `<?php echo $TABLE_PREFIX ?>registration_forms` WHERE facebookmarketing='1' LIMIT 1000
You've got the right idea in your example, so there may be something less obvious going on. When you say the screen is blank, does that mean that the page does not load, or that it just returns no rows? If the page does not load, could you check the Developer Log to see if any errors show up when you try to load the report? Also, do you have any other reports that are working?
Thanks for pointing me in the right direction. I didn't think to look in the developer log.
The developer log says: _ERROR: Call to undefined function mysqli()
This site is running version 3.07 and using php 5.6.4, so my first action should probably be to get everything up to date.
To be honest I've been avoiding it because you've done quite a bit of custom code to it and I am worried that something mysqli related is going to break – but I have to take the plunge at some point!