AndyJarrett Code. Develop. Manage.

BlogCFC, stats.cfm and MySQL

Just been playing around with Rays new Blog Stats, which is pretty sweet, if you haven't got it all ready I recommend downloading it now. Anyway to get it working with MySQL i had to make a couple of small changes. Namely just changing the "ORDER BY" line to use the alias and not count(col_name) and remove TOP 10 and replaced with LIMIT 10. If you want to use my edited MySQL friendly version of his code you can get it at
I’m here, learning and working away. If you liked this content and want to keep me going, consider buying me a coffee.
Your support keeps this site running and the coffee brewing! ☕️