#1 Drupal Development Book: http://amzn.to/1PwoAo3
Visit www.torontowebsitedeveloper.com to purchase drupal video tutorials.
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.