manual new product field adding help

[montana_girl]

Hi- can someone help me with this portion of the manual install? of newfeilds4

 

i manually added the field i wanted into the products table...

 

First using PhpMyAdmin click on the products table on the left. Add a new field called products_whatyouwant, set the type to varchar(45), Null to null and default to NULL.

 

now it tells me to do this, but i'm not that great of a code writer and figured i'd ask for help first.

 

Using PhpMyAdmin there are 2 tables we need to play with: ‘configuration_group’; and configuration.

 

 

These columns are in Configuration_group table:

 

configuration_group_id

configuration_group_title

configuration_group_description

sort_order

 

These columns are in the configuration table:

 

configuration_key = PRODUCT_LIST_ARTIST

configuration_title = Display Artist

sort_order = max + 1 (this is the order it displays in the admin suite)

configuration_group_id = 8

configuration_value = 2 (this is the order it displays in the product_listing.php file.. setting it to zero means it will not be displayed)

 

Look in the configuration_group table to find the configuration_group_id for Product Listing,

 

Then insert new rows to the configuration table, using the configuration_group_id you found in the configuration_group table.

 

I have found it difficult to use the admin suite to configure new columns, so if you wish to hide a column or make a hidden column visible it is advisable to just alter the configuration_value in the database.

 

in other contributions i have seen sql commands do this, but when i tried writing one i got an error...