This is a thread offshoot from the one I created about FOREACH Loops. An off topic discussion started so I am creating this new thread to continue those.

Here is the preliminary discussion starter I am pasting from Steve Johnson from that other thread.





Response:

Yeah Steve, I took a look at that ezSQL and read through the introduction page... The only thing I see for me of value there is the caching feature.

I actually created a couple functions that handle most the mysql calls I need, I just need to call them and choose what sort of output I want and it just takes care of it for me.

In cases where I need more specific results I created a function that all I need to do is pass a properly formatted SQL Query and it parses the data, sanitizes the data and returns it in various formats or data sets via a toggle I pass to the function.

It might of been easier to use something like this ezSQL to build this but I got it now and it works great and I just have one line to embed in any page to get whatever data I need.

Looking through the introduction page in that ezSQL my calls are actually smaller than the ones they have in their samples. Only thing I don't have that they do is caching. Maybe I will just convert some of these dynamically created pages into static pages that way no need for database caching.. LOL

Thanks,

- T