I don't understand what you mean regarding the menu. But regarding you question about if its possible to use a second database - yes it is, provididing they are both the same type (ie, two Mysql databases). Change settings.php to read:

$db_url['default'] = 'mysql://username1:password1@localhost/drupal';
$db_url['otherdb'] = 'mysql://username2:password2@localhost/otherdb';

And to query it:

db_set_active('otherdb');

//Run queries as normal

db_set_active('default');

Don't forget to set the active database back to default when you are done, or interesting things happen.

2009/11/16 spartaguy spartaguy <spartaguy300@gmail.com>

 I want to do a select on a table and just display the results in main window pane.

ie header is standard logo, left hand side is navigation menu.
One of the navigation items should be able to do a query on a table in the local drupal database or ideally in a separate database.

the mysql syntax is the easy part. its the creating a menu item that will do the mysql select statement and display the results in the main window pane.

Does this make sense?


Paul


On Mon, Nov 16, 2009 at 10:37 AM, Nancy Wichmann <nan_wich@bellsouth.net> wrote:

Spartaguy wrote:

> How can I add a menu item to the Primary Links menu that will do a select * from table1 and then print it out in the right hand panel?
Your information is less than complete.

 

Select on what? Is there a dialog of some sort? I’m guessing what you really want is a block.

 

Nancy E. Wichmann, PMP

Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.