[support] are mysql queries in drupal possible?

[Metzler, David]

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 at drupal.org [mailto:support-bounces at drupal.org] On
Behalf Of spartaguy spartaguy
Sent: Friday, November 13, 2009 8:47 PM
To: support at 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 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/support/attachments/20091116/47c0c225/attachment.html