CREATE TABLE `tbl_panel_fee` (
`pf_id` int(11) NOT NULL auto_increment,
`panel_id` int(11) NOT NULL default '0',
`pf_min` int(11) unsigned default NULL,
`pf_max` int(11) unsigned default NULL,
PRIMARY KEY (`pf_id`),
KEY `panel_id` (`panel_id`),
KEY `pf_min` (`pf_min`),
KEY `pf_max` (`pf_max`),
KEY `pf_min_2` (`panel_id`,`pf_min`,`pf_max`)
)
!!We have two rows initially with:
uniqueid, 7, 6, 125, 987654704
uniqueid, 13, 6, 125, 987654704
!!I then run the following two querys:
REPLACE INTO tbl_panel_valfirm_fee(valfirm_id, cl_funder_id, pvf_fee, panel_id)
VALUES (7, 6, 200, '987654704')
REPLACE INTO tbl_panel_valfirm_fee(valfirm_id, cl_funder_id, pvf_fee, panel_id)
VALUES (13, 6, 125, '987654704')
!!I then get
uniqueid, 7, 6, 200, 987654704
uniqueid, 13, 6, 200, 987654704
!!instead of the
uniqueid, 7, 6, 200, 987654704
uniqueid, 7, 6, 125, 987654704
!!that i expected.