(1) I am I right in thinking that I would have the below table structure...but also for the other delivery options (rest of world, 1stclass, 2nd class and Recorded) - so that would be 5 seperate tables in my database.
CREATE TABLE IF NOT EXISTS `deliveryeurope` (
`DeliveryEuropeID` int(11) unsigned NOT NULL AUTO_INCREMENT,
`DeliveryEuropeMin` int(11) unsigned NOT NULL,
`DeliveryEuropeMax` int(11) unsigned NOT NULL,
`DeliveryEuropeAmount` float NOT NULL,
PRIMARY KEY (`DeliveryEuropeID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
(2) each of the above 5 tables would have a recordset. - how would I set the record set up on the page?
(3) each of the above 5 tables would have a ecart shipping rule. - what would the rule consist of..i know from an earlier post it would check the value of the weight in the cart..but for the "create a flat rate shipping of $ ..i would put the session variable of what type of session creation process? (how would the session be created on the page)
sorry for my dumb questions since i have done something simular before., just wanted to get it right in my head before i code it.