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 :andyjarrett.co.uk/downloads/stats-mysql-friendly.zip
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! ☕️