Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

help need to add this query to database


Recommended Posts

how do i add this query to my database im kinda new so really dumb when it comes to things like this.


The first is to enable the display of Products Description in the Listing 0 = No 99 = Yes

INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('', 'Display Product Description', 'PRODUCT_LIST_DESCRIPTION', '99', 'Set to 0 to disable, set to 99 to enable.', '8', '11', '', '', NULL, NULL);


The second defines the number of characters to display before truncating the description

INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('', 'Length of Truncated Product Description', 'PRODUCT_LIST_DESCRIPTION_LENGTH', '350', 'How many characters would you like to display? ', '8', '12', '2002-03-16 18:51:26', '2002-03-16 18:51:26', NULL, NULL);


any help will be great thanks

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...