Multiple info in one field

[fernyburn]

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

[swampBoogie]

Don't store multiple values in one column. Create a separate table with two columns, one for product and for coupon. Store one row for each combination of product and coupon.