Thanks to everyone that replied. To summarise then: 1) I need to make a custom module. 2) The module should have a block for displaying the query and a menu hook 3) I can add the module to either primary links or navigation as a menu item 4) Rendered HTML using mysql commands is quite straight forward 5) The tables being queried are easier to access within the main drupal d/b but i can use a different db Regarding a different db, does this command: db_set_active('customerdb'); make *all* db queries go through customerdb or just the ones for my module? ie will drupal have any issues accessing the data it needs from say "drupaldb" if I dont change the active db back again? On Tue, Nov 17, 2009 at 9:27 AM, Earl Dunovant <prometheus6@gmail.com>wrote:
On Mon, Nov 16, 2009 at 7:55 AM, spartaguy spartaguy < spartaguy300@gmail.com> wrote:
I have two databases - one is for drupal data. The other db is for customer data. Inside the customer data db is a table - customer_data.
I want to do a select * on customer_data in the customer database and show the result on screen.
Can someone tell me how to do this?
Your bare bones menu item is something like this:
$items['mypath/%object'] = array( 'title' => 'Page title', 'description' => 'Your description goes here.', 'access arguments' => array('permission string'), 'page callback' => 'customer_display', );
Then write a function named customer_display() that runs queries the way Frederik showed you and returns a string containing rendered HTML.