Drupal 6: Taking a SQL statement and generating a table from the results
Functionality that I regularly create in applications is the ability to take a SQL statement and return a table of results for reports, debugging, etc. Here’s a helper function I created to implement this functionality. I purposely left off pagination, sortable columns, and other features to focus on how the Drupal theme_table() function operates. This helper function will use the column names from the SQL as the table column headers, so make sure they are properly formatted.