By rmahon on

I have a program that stores it’s output in a MYSQL
Database. I would like to include a subset of this data in a Drupal site. I was
wondering what is the best way to do this. Any help and or suggestions will be greatly
appreciated.
 
Thanks
Ron

⋅ Categories: Drupal 5.x

Comments

cog.rusty’s picture

cog.rusty commented

Here is how to connect to alternative databases from inside Drupal
http://drupal.org/node/18429

Or, to save yourself some effort, you could add your database tables in Drupal's database, with their names prefixed with something, like all Drupal modules do.

You can display your data either using php code in Drupal nodes or blocks, or writing a module of yours (which is the best).

rmahon’s picture

rmahon commented

I had all ready moved the table in to the Drupal database.
I will try the "db_query: which is probable why my sql statement did not work.

Thanks
For the help

Ron Mahon
http://The-villages-info-center.com
Yet another Drupal Site

pwolanin’s picture

pwolanin commented

this module I wrote to cover roughly such purposes - http://drupal.org/project/object_driver

you'll still have to define the data that's in your MySQL table in a small module, and note that I'm not making any particular promises about a 6.x update.

---
Work: BioRAFT

rmahon’s picture

rmahon commented

I upload the module and enabled it but it did not install the database household table.

I will try installing the it as another module.

Ron Mahon
http://The-villages-info-center.com
Yet another Drupal Site

rmahon’s picture

rmahon commented

This is a very elegant solution could solve a lot of my problems.

I separated the member list in to it's own module and it created a empty database table "household".
My question is how do I run this after I populate the table with data?
Thanks for you help.
Ron

Ron Mahon
http://The-villages-info-center.com
Yet another Drupal Site

ron_mahon’s picture

ron_mahon commented

The primary key need to be class_id ie clubs_id
Great way to understand how to program The Drupal way.

Thanks
Ron Mahon
Alias "Link" at
www.The-Villages-info-center.com

ron_mahon’s picture

ron_mahon commented

all thought the solution stated worked if was not integrated in to drupal.
one could not search for content fields did not collapse for smaller screens etc.

Thanks to Jeremy at tag one consulting, it's up and running is only one weeks time.
The solution involved some custom php script and CCK & Views.

I highly recommend these people. Very workable.

Jeremy Andrews
877-875-8824 x100
Tag1 Consulting, Inc.
http://tag1consulting.com/

Ron Mahon
Alias "Link" at
http://The-Villages-info-center.com