[development] new dev q: are mysql queries possible within drupal?

[spartaguy spartaguy]

Hi,

 How can add an item to the Primary links Menu that will do a basic select
query within drupal?
ie Lets say I have a mysql database "database1"  and a table "table1" with
the following fields (name, address, email etc)

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?

Is this possible? Does it have to be the same database drupal uses or can I
query a different db?


Paul


ps. The result would be something like:

Joe Blow        |       123 abc avenue     |     joeblow at applecart.org
Joe Blow1      |       12323 abc avenue     |     joeblow1 at applecart.org
Joe Blow2     |       12323 abc avenue     |     joeblow2 at applecart.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/development/attachments/20091116/33624073/attachment.html