Hi
I have some code made up for my oscommerce webshop
Basically its a coupons modification, but im having a problem with my database configuration.
Basically I can choose multiple products to apply a discount to
however, when it goes into the database it only stores the 1st one
how, or where do i get it to store many
this is my table
Quote:
CREATE TABLE IF NOT EXISTS `coupons` (
`coupons_id` int(10) unsigned NOT NULL auto_increment,
`coupons_code` varchar(32) NOT NULL,
`coupons_value` decimal(15,4) NOT NULL,
`product_ids` int(10) unsigned NOT NULL,
`type` varchar(32) NOT NULL,
`num_times` int(11) NOT NULL default '0',
`total_times` int(11) NOT NULL default '0',
`coupons_notice` varchar(250) NOT NULL,
`coupons_min_order` int(11) NOT NULL default '0',
`coupons_date` date default NULL,
PRIMARY KEY (`coupons_id`),
KEY `idx_code` (`coupons_code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
|
`product_ids` int(10) unsigned NOT NULL,
is the row it goes into - how do i make take multiple numbers
Thanks |
