Not sure what you mean by right hand panel, but sounds like you want to implement a custom module that provides a block and a menu any module provided menu can be moved around using admin menus. And blocks, once created can be put in any place on a theme. The odd thing about your request is what happens to the rest of the screen when the user clicks on the link. You'll have to be careful about how you implement that from a UI perspective.
Yes you can have drupal query other tables, or use your own php code to get data from any source you'd like.
Would recommend getting a copy of drupal pro development and reading the module developers pages Documentation pages at drupal.org.
http://drupal.org/contributors-guide
Dave
________________________________
From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of spartaguy spartaguy Sent: Friday, November 13, 2009 8:47 PM To: support@drupal.org Subject: [support] are mysql queries in drupal possible?
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?
Paul
ps. The result would be something like:
Joe Blow | 123 abc avenue | joeblow@applecart.org Joe Blow1 | 12323 abc avenue | joeblow1@applecart.org Joe Blow2 | 12323 abc avenue | joeblow2@applecart.org