db_set_active('customerdb');
// Make your custom queries
db_set_active(); // Returns back to the Drupal database
Jamie Holly
http://www.intoxination.net
http://www.hollyit.net
spartaguy spartaguy wrote:
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 <[email protected]
<mailto:[email protected]>> wrote:
On Mon, Nov 16, 2009 at 7:55 AM, spartaguy spartaguy
<[email protected] <mailto:[email protected]>> 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.
