
Originally Posted by
chowardart
OK, I was successful at adding the info manually to the database by MySQL, which is where I have some experience. Where I don't have experience with is in these sql files, and I wanted to ask, if I were to create the following and save it as an sql file, would it work?
Here's the code I came up with:
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES
(NULL, 'Banner Display Groups - Rapslide6', 'SHOW_BANNERS_GROUP_SETRAP6', 'rapslide6', 'Rapslide 6', @configuration_group_id, 34, NOW(), NULL, NULL);
INSERT INTO `banners` (`banners_id`, `banners_title`, `banners_url`, `banners_image`, `banners_group`, `banners_html_text`, `expires_impressions`, `expires_date`, `date_scheduled`, `date_added`, `date_status_change`, `status`, `banners_open_new_windows`, `banners_on_ssl`, `banners_sort_order`) VALUES
('', 'rapslide6', 'http://www.picaflor-azul.com', 'banners/rapslide6.jpg', 'rapslide6', NULL, '0', NULL, NULL, '0001-01-01 00:00:00', NULL, '1', '1', '1', '0');
Does this kind of code need any headers or closing statements? (Yes, I AM a student at all of this...)
Thanks for your help!
Bookmarks