How to view SQL generated by Query Builder?

PHP, good idea to run the query directly. I ran it within phpMyAdmin. Seems I modified one of the columns, qualified from a digit to a string. I had assumed all of the fields set to 1 would convert to "yes". They did not and once I saw that in the phoMyAdmin, it became clear that was the issue. Thx.

Just read through the document you recommended:
>>Also, don't forget that you can use query binding (https://codeigniter.com/user_guide/datab...y-bindings) instead of the query builder.

sounds perfect for my needs. thanks again, Rich

proof that an old dog can learn new tricks