Drupal 7 Module Development Tutorial #6 - Querying the Database with DB_SELECT
In this six drupal video tutorial, I show you how we can get information from the database using db_select. To do so, we need to build a query using the Drupal database API. We do so by starting with a simple db_select call, followed by joining our tables. Then we add our fields, order our results and finish it all off by extending the query to use a pager.