<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16809" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=871145815-16112009><FONT face=Arial
color=#0000ff size=2>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. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=871145815-16112009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=871145815-16112009><FONT face=Arial
color=#0000ff size=2>Yes you can have drupal query other tables, or use your own
php code to get data from any source you'd like. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=871145815-16112009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=871145815-16112009><FONT face=Arial
color=#0000ff size=2>Would recommend getting a copy of drupal pro development
and reading the module developers pages Documentation pages at drupal.org.
</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=871145815-16112009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=871145815-16112009><FONT face=Arial
color=#0000ff size=2><A
href="http://drupal.org/contributors-guide">http://drupal.org/contributors-guide</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=871145815-16112009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=871145815-16112009><FONT face=Arial
color=#0000ff size=2>Dave</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=871145815-16112009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=871145815-16112009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> support-bounces@drupal.org
[mailto:support-bounces@drupal.org] <B>On Behalf Of </B>spartaguy
spartaguy<BR><B>Sent:</B> Friday, November 13, 2009 8:47 PM<BR><B>To:</B>
support@drupal.org<BR><B>Subject:</B> [support] are mysql queries in drupal
possible?<BR></FONT><BR></DIV>
<DIV></DIV><BR><BR>Hi,<BR><BR> How can add an item to the Primary links
Menu that will do a basic select query within drupal?<BR>ie Lets say I have a
mysql database "database1" and a table "table1" with the following fields
(name, address, email etc)<BR><BR>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?<BR><BR>Is this possible?<BR><BR><BR>Paul<BR><BR><BR>ps. The result would
be something like:<BR><BR>Joe Blow
| 123 abc avenue
| <A
href="mailto:joeblow@applecart.org">joeblow@applecart.org</A><BR>Joe
Blow1 | 12323
abc avenue | <A
href="mailto:joeblow1@applecart.org">joeblow1@applecart.org</A><BR>Joe
Blow2 | 12323 abc
avenue | <A
href="mailto:joeblow2@applecart.org">joeblow2@applecart.org</A><BR><BR></BODY></HTML>