Greg Aker on the Query Module
EllisLab employee (and, sadly, Kansas basketball fan) Greg Aker drops a knowledge bomb on using custom queries with the ExpressionEngine Query Module instead of a standard Channel Entries tag pair.
The Query Module in ExpressionEngine is one of my most favorite, and I think one of the most underutilized gems of the product. As I have previously discussed, it’s almost always better to use a Plugin or Module rather than turning on PHP in your templates. If the weblog/channel module is overkill, the query module is where it’s at.
You need to know how to write MySQL queries, and need to study the ExpressionEngine schema a bit. After getting that under your belt, you’ll have a new weapon in your arsenal to attack content layout issues with.
Last week I released a new one hour training video covering the basics of MySQL and ExpressionEngine. Aker’s tip is a great follow-up on that primer.
Read the whole article: Greg Aker: Get your SQL on
Posted on Feb 16, 2011 by Ryan Irelan
Share on Twitter