How would one implement such a system via a drupal module?

I have a simple database table with fields like:

Model, Type, Area, Height, Temperature, Range, Light Intensity

Would I just create the table as is, or use the Drupal node API to somehow create and hold the data?

What is the simplest (even hackish) approach? From a complete novies perspective in Drupal experience?

Edited by WorldFallz - moved to appropriate forum.

Comments

markDrupal’s picture

Easiest way to do this is to use CCK module and create a content type with fields you need : Model, Type, Area, Height, Temperature, Range, Light Intensity.

It will create a table in your database called 'content_type_physics with db columns : field_model, field_type, field_area, etc...

If you want to create something more flexable, but it requires 25x the work to create, you can create a custom module with and install file that sets up your database

GarbageXAY1979’s picture

I am very new to Drupal...have zero knowledge of CCK other than what the acronym stands for...this would be easier than building the table manually? Does CCK handle the form and table comparison as well? Basically the product comparison will have a single form which consists of three comboboxes, each with a product model. When submitted the module would need to generate a tabluar comparison chart (HTML tables are fine) of the products for side by side review.

markDrupal’s picture

The CCK is Content Construction Kit (CCK) http://drupal.org/project/cck It allows you to create new content types with a number of custom fields, it would work perfectly for you to input your data into the database. However it is only a way for you to input and display your data. It will not compare 2 items.

You most likely would need to get a drupal programmer to make a comparison module.
Take a look at these other discussion on comparison modules for drupal (or lack there of) :

http://drupal.org/node/516142
http://drupal.org/node/507506
http://drupal.org/node/116912
http://drupal.org/node/233535
http://drupal.org/node/196046

budgetstockphoto’s picture

the verses module sounds good, but sadly not for D6

http://drupal.org/project/versus

it would also need to have an option to allow the user to pick two sites to display from dropdowns instead of just random.

would this not work best as a view display plugin that took two arguments, and exposed them if needed, and then displayed fields chosen in the view from the two like module types that had been picked?

summit’s picture

Subscribing, shouldn't ubercart be a starting point?
greetings, Martijn