Drupal Hosts : Traditional mySQL tables and queries in Drupal

Hostgator web hosting is our best host for drupal. Sign up with our recommended host for drupal here

This is a drupal question asked by a.bond on 03 April 2009

My company is currently migrating it’s system from standard HTML/PHP/mySQL to Drupal. One page that I can’t figure out how to move is a page that pulls future and past content titles from a table, checks the list against the current week (arbitrarily defined) and outputs the result. However, I’m not sure how to re-implement this in Drupal. Should I use standard mySQL queries, or the Drupal functions? The table and titles will need to be manually generated, not updated through the Drupal system, so I don’t know if the Drupal functions can select tables other than the tables Drupal creates.

To make it more clear what I’m doing, here’s the code we were using before:

More info at this drupal node or sign up with the popular choice for drupal hosting