Tweet
i tried to transferred the sql database from remote to local and then i got this error message
this is the whole code of table `orders_total`see below
Code:
-- -- Dumping data for table `orders_total` -- INSERT INTO `orders_total`
(`orders_total_id`, `orders_id`, `title`, `text`, `value`, `class`, `sort_order`)
VALUES (128, 42, 'Sub-Total:', 'S$400.00', 400.0000, 'ot_subtotal', 1),
(129, 42, 'United Parcel Service (1 pkg x 0 kgs total)
(UPS Worldwide Expedited (billed dimensional weight 1 KGS)):',
'S$52.86', 52.8600, 'ot_shipping', 2), (130, 42, 'Total:', 'S$452.86', 452.8600, 'ot_total', 4),
(131, 43, 'Sub-Total:', 'S$0.00', 0.0000, 'ot_subtotal', 1),
(132, 43, 'United Parcel Service (1 pkg x 0 kgs total)
(UPS Worldwide Expedited (billed dimensional weight 1 KGS)):',
'S$51.26', 51.2600, 'ot_shipping', 2),
(133, 43, 'Total:', 'S$51.26', 51.2600, 'ot_total', 4),
(134, 44, 'Sub-Total:', 'S$560.00', 560.0000, 'ot_subtotal', 1),
(135, 44, 'United Parcel Service (1 pkg x 6 kgs total)
(UPS Worldwide Expedited
(billed dimensional weight 6 KGS)):', 'S$130.78', 130.7800, 'ot_shipping', 2),
(136, 44, 'Total:', 'S$690.78', 6[...]
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '&phpMyAdmin=f-p9NsQGHzXwuAlzpV8o27R%2CY2f 'S$0.00', 0.0000, 'ot_shipping', 2),
(' at line 206
this is the whole code of table `orders_total`see below
Code:
CREATE TABLE `orders_total` ( `orders_total_id` int(10) unsigned NOT NULL auto_increment, `orders_id` int(11) NOT NULL, `title` varchar(255) NOT NULL, `text` varchar(255) NOT NULL, `value` decimal(15,4) NOT NULL, `class` varchar(32) NOT NULL, `sort_order` int(11) NOT NULL, PRIMARY KEY (`orders_total_id`), KEY `idx_orders_total_orders_id` (`orders_id`) ) ENGINE=InnoDB AUTO_INCREMENT=1225 DEFAULT CHARSET=utf8 AUTO_INCREMENT=1225 ; -- -- Dumping data for table `orders_total` -- INSERT INTO `orders_total` (`orders_total_id`, `orders_id`, `title`, `text`, `value`, `class`, `sort_order`) VALUES (128, 42, 'Sub-Total:', 'S$400.00', 400.0000, 'ot_subtotal', 1), (129, 42, 'United Parcel Service (1 pkg x 0 kgs total) (UPS Worldwide Expedited (billed dimensional weight 1 KGS)):', 'S$52.86', 52.8600, 'ot_shipping', 2), (130, 42, 'Total:', '<b>S$452.86</b>', 452.8600, 'ot_total', 4), (131, 43, 'Sub-Total:', 'S$0.00', 0.0000, 'ot_subtotal', 1), (132, 43, 'United Parcel Service (1 pkg x 0 kgs total) (UPS Worldwide Expedited (billed dimensional weight 1 KGS)):', 'S$51.26', 51.2600, 'ot_shipping', 2), (133, 43, 'Total:', '<b>S$51.26</b>', 51.2600, 'ot_total', 4), (134, 44, 'Sub-Total:', 'S$560.00', 560.0000, 'ot_subtotal', 1), (135, 44, 'United Parcel Service (1 pkg x 6 kgs total) (UPS Worldwide Expedited (billed dimensional weight 6 KGS)):', 'S$130.78', 130.7800, 'ot_shipping', 2), (136, 44, 'Total:', '<b>S$690.78</b>', 690.7800, 'ot_total', 4), (137, 45, 'Sub-Total:', 'S$150.00', 150.0000, 'ot_subtotal', 1), (138, 45, 'United Parcel Service (1 pkg x 0 kgs total) (UPS Worldwide Expedited (billed dimensional weight 1 KGS)):', 'S$51.26', 51.2600, 'ot_shipping', 2), (139, 45, 'Total:', '<b>S$201.26</b>', 201.2600, 'ot_total', 4), (140, 46, 'Sub-Total:', 'S$150.00', 150.0000, 'ot_subtotal', 1), (141, 46, 'United Parcel Service (1 pkg x 0 kgs total) (UPS Worldwide Expedited (billed dimensional weight 1 KGS)):', 'S$51.26', 51.2600, 'ot_shipping', 2), (142, 46, 'Total:', '<b>S$201.26</b>', 201.2600, 'ot_total', 4), (143, 47, 'Sub-Total:', 'S$710.00', 710.0000, 'ot_subtotal', 1), (144, 47, 'United Parcel Service (1 pkg x 0 kgs total) (UPS Worldwide Expedited (billed dimensional weight 1 KGS)):', 'S$54.46', 54.4600, 'ot_shipping', 2), (145, 47, 'Total:', '<b>S$764.46</b>', 764.4600, 'ot_total', 4), (146, 48, 'Sub-Total:', 'S$560.00', 560.0000, 'ot_subtotal', 1), (147, 48, 'United Parcel Service (1 pkg x 6 kgs total) (UPS Worldwide Expedited (billed dimensional weight 6 KGS)):', 'S$130.78', 130.7800, 'ot_shipping', 2), (148, 48, 'Total:', '<b>S$690.78</b>', 690.7800, 'ot_total', 4), (149, 49, 'Sub-Total:', 'S$550.00', 550.0000, 'ot_subtotal', 1), (150, 49, 'United Parcel Service (1 pkg x 6 kgs total) (UPS Worldwide Expedited (billed dimensional weight 6 KGS)):', 'S$130.78', 130.7800, 'ot_shipping', 2), (151, 49, 'Total:', '<b>S$680.78</b>', 680.7800, 'ot_total', 4), (152, 50, 'Sub-Total:', 'S$0.00', 0.0000, 'ot_subtotal', 1), (153, 50, 'United Parcel Service (1 pkg x 0 kgs total) (UPS Worldwide Expedited (billed dimensional weight 1 KGS)):', 'S$51.26', 51.2600, 'ot_shipping', 2), (154, 50, 'Total:', '<b>S$51.26</b>', 51.2600, 'ot_total', 4), (155, 51, 'Sub-Total:', 'S$0.00', 0.0000, 'ot_subtotal', 1), (156, 51, 'United Parcel Service (1 pkg x 0 kgs total) (UPS Worldwide Expedited (billed dimensional weight 1 KGS)):', 'S$51.26', 51.2600, 'ot_shipping', 2), (157, 51, 'Total:', '<b>S$51.26</b>', 51.2600, 'ot_total', 4), (158, 52, 'Sub-Total:', 'S$0.00', 0.0000, 'ot_subtotal', 1), (159, 52, 'United Parcel Service (1 pkg x 0 kgs total) (UPS Worldwide Expedited (billed dimensional weight 1 KGS)):', 'S$51.26', 51.2600, 'ot_shipping', 2), (160, 52, 'Total:', '<b>S$51.26</b>', 51.2600, 'ot_total', 4), (161, 53, 'Sub-Total:', 'S$0.00', 0.0000, 'ot_subtotal', 1), (162, 53, 'United Parcel Service (1 pkg x 0 kgs total) (UPS Worldwide Expedited (billed dimensional weight 1 KGS)):', 'S$51.26', 51.2600, 'ot_shipping', 2), (163, 53, 'Total:', '<b>S$51.26</b>', 51.2600, 'ot_total', 4), (164, 54, 'Sub-Total:', 'S$0.00', 0.0000, 'ot_subtotal', 1), (165, 54, 'United Parcel Service (1 pkg x 0 kgs total) (UPS Worldwide Expedited (billed dimensional weight 1 KGS)):', 'S$51.26', 51.2600, 'ot_shipping', 2), (166, 54, 'Total:', '<b>S$51.26</b>', 51.2600, 'ot_total', 4), (167, 55, 'Sub-Total:', 'S$300.00', 300.0000, 'ot_subtotal', 1), (168, 55, 'United Parcel Service (1 pkg x 0 kgs total) (UPS Worldwide Expedited (billed dimensional weight 1 KGS)):', 'S$52.06', 52.0600, 'ot_shipping', 2), (169, 55, 'Total:', '<b>S$352.06</b>', 352.0600, 'ot_total', 4), (170, 56, 'Sub-Total:', 'S$0.00', 0.0000, 'ot_subtotal', 1), (171, 56, 'United Parcel Service (1 pkg x 0 kgs total) (UPS Worldwide Expedited (billed dimensional weight 1 KGS)):', 'S$51.26', 51.2600, 'ot_shipping', 2), (172, 56, 'Total:', '<b>S$51.26</b>', 51.2600, 'ot_total', 4), (173, 57, 'Sub-Total:', 'S$550.00', 550.0000, 'ot_subtotal', 1), (174, 57, 'United Parcel Service (1 pkg x 6 kgs total) (UPS Worldwide Expedited (billed dimensional weight 6 KGS)):', 'S$130.78', 130.7800, 'ot_shipping', 2), (175, 57, 'Total:', '<b>S$680.78</b>', 680.7800, 'ot_total', 4), (176, 58, 'Sub-Total:', 'S$900.00', 900.0000, 'ot_subtotal', 1), (177, 58, 'United Parcel Service (1 pkg x 0 kgs total) (UPS Worldwide Expedited (billed dimensional weight 1 KGS)):', 'S$55.26', 55.2600, 'ot_shipping', 2), (178, 58, 'Total:', '<b>S$955.26</b>', 955.2600, 'ot_total', 4), (179, 59, 'Sub-Total:', 'S$550.00', 550.0000, 'ot_subtotal', 1), (180, 59, 'United Parcel Service (1 pkg x 6 kgs total) (UPS Worldwide Expedited (billed dimensional weight 6 KGS)):', 'S$130.78', 130.7800, 'ot_shipping', 2), (181, 59, 'Total:', '<b>S$680.78</b>', 680.7800, 'ot_total', 4), (182, 60, 'Sub-Total:', 'S$560.00', 560.0000, 'ot_subtotal', 1), (183, 60, 'United Parcel Service (1 pkg x 6 kgs total) (UPS Worldwide Expedited (billed dimensional weight 6 KGS)):', 'S$130.78', 130.7800, 'ot_shipping', 2), (184, 60, 'Total:', '<b>S$690.78</b>', 690.7800, 'ot_total', 4), (185, 62, 'Sub-Total:', 'S$1,680.00', 1680.0000, 'ot_subtotal', 1), (186, 62, 'United Parcel Service (1 pkg x 18 kgs total) (UPS Worldwide Expedited (billed dimensional weight 18 KGS)):', 'S$207.08', 207.0800, 'ot_shipping', 2), (187, 62, 'Total:', '<b>S$1,887.08</b>', 1887.0800, 'ot_total', 4), (188, 63, 'Sub-Total:', 'S$560.00', 560.0000, 'ot_subtotal', 1), (189, 63, 'United Parcel Service (1 pkg x 6 kgs total) (UPS Worldwide Expedited (billed dimensional weight 6 KGS)):', 'S$130.78', 130.7800, 'ot_shipping', 2), (190, 63, 'Total:', '<b>S$690.78</b>', 690.7800, 'ot_total', 4), (191, 64, 'Sub-Total:', 'S$888.00', 888.0000, 'ot_subtotal', 1), (192, 64, 'United Parcel Service (1 pkg x 12 kgs total) (UPS Worldwide Expedited (billed dimensional weight 12 KGS)):', 'S$182.71', 182.7100, 'ot_shipping', 2), (193, 64, 'Total:', '<b>S$1,070.71</b>', 1070.7100, 'ot_total', 4), (194, 65, 'Sub-Total:', 'S$448.00', 448.0000, 'ot_subtotal', 1), (195, 65, 'United Parcel Service (1 pkg x 6 kgs total) (UPS Worldwide Expedited (billed dimensional weight 6 KGS)):', 'S$130.78', 130.7800, 'ot_shipping', 2), (196, 65, 'Total:', '<b>S$578.78</b>', 578.7800, 'ot_total', 4), (197, 66, 'Sub-Total:', 'S$448.00', 448.0000, 'ot_subtotal', 1), (198, 66, 'United Parcel Service (1 pkg x 6 kgs total) (UPS Worldwide Expedited (billed dimensional weight 6 KGS)):', 'S$129.98', 129.9800, 'ot_shipping', 2), (199, 66, 'Total:', '<b>S$577.98</b>', 577.9800, 'ot_total', 4), (200, 67, 'Sub-Total:', 'S$448.00', 448.0000, 'ot_subtotal', 1), (201, 67, 'United Parcel Service (1 pkg x 6 kgs total) (UPS Worldwide Expedited (billed dimensional weight 6 KGS)):', 'S$129.98', 129.9800, 'ot_shipping', 2), (202, 67, 'Total:', '<b>S$577.98</b>', 577.9800, 'ot_total', 4), (203, 68, 'Sub-Total:', 'S$448.00', 448.0000, 'ot_subtotal', 1), (204, 68, 'United Parcel Service (1 pkg x 6 kgs total) (UPS Worldwide Expedited (billed dimensional weight 6 KGS)):', 'S$129.98', 129.9800, 'ot_shipping', 2), (205, 68, 'Total:', '<b>S$577.98</b>', 577.9800, 'ot_total', 4), (206, 69, 'Sub-Total:', 'S$456.00', 456.0000, 'ot_subtotal', 1), (207, 69, 'United Parcel Service (1 pkg x 6 kgs total) (UPS Worldwide Expedited (billed dimensional weight 6 KGS)):', 'S$128.38', 128.3800, 'ot_shipping', 2), (208, 69, 'Total:', '<b>S$584.38</b>', 584.3800, 'ot_total', 4), (209, 70, 'Sub-Total:', 'S$1,057.00', 1057.0000, 'ot_subtotal', 1), (210, 70, 'United Parcel Service (1 pkg x 13 kgs total) (UPS Worldwide Expedited (billed dimensional weight 13 KGS)):', 'S$191.30', 191.3000, 'ot_shipping', 2), (211, 70, 'Total:', '<b>S$1,248.30</b>', 1248.3000, 'ot_total', 4), (212, 71, 'Sub-Total:', 'S$392.00', 392.0000, 'ot_subtotal', 1), (213, 71, 'United Parcel Service (1 pkg x 6 kgs total) (UPS Worldwide Expedited (billed dimensional weight 6 KGS)):', 'S$129.98', 129.9800, 'ot_shipping', 2), (214, 71, 'Total:', '<b>S$521.98</b>', 521.9800, 'ot_total', 4), (215, 72, 'Sub-Total:', 'S$385.00', 385.0000, 'ot_subtotal', 1), (216, 72, 'United Parcel Service (1 pkg x 6 kgs total) (UPS Saver (billed dimensional weight 6 KGS)):', 'S$143.85', 143.8500, 'ot_shipping', 2), (217, 72, 'Total:', '<b>S$528.85</b>', 528.8500, 'ot_total', 4), (218, 73, 'Sub-Total:', 'S$920.00', 920.0000, 'ot_subtotal', 1), (219, 73, 'United Parcel Service (1 pkg x 12 kgs total) (UPS Worldwide Expedited (billed dimensional weight 12 KGS)):', 'S$183.51', 183.5100, 'ot_shipping', 2), (220, 73, 'Total:', '<b>S$1,103.51</b>', 1103.5100, 'ot_total', 4), (221, 74, 'Sub-Total:', 'S$732.00', 732.0000, 'ot_subtotal', 1), (222, 74, 'United Parcel Service (1 pkg x 6 kgs total) (UPS Worldwide Expedited (billed dimensional weight 6 KGS)):', 'S$131.58', 131.5800, 'ot_shipping', 2), (223, 74, 'Total:', '<b>S$863.58</b>', 863.5800, 'ot_total', 4), (224, 75, 'Sub-Total:', 'S$392.00', 392.0000, 'ot_subtotal', 1), (225, 75, 'United Parcel Service (1 pkg x 6 kgs total) (UPS Worldwide Expedited (billed dimensional weight 6 KGS)):', 'S$107.62', 107.6200, 'ot_shipping', 2), (226, 75, 'Total:', '<b>S$499.62</b>', 499.6200, 'ot_total', 4), (227, 76, 'Sub-Total:', 'S$1,155.00', 1155.0000, 'ot_subtotal', 1), (228, 76, 'United Parcel Service (1 pkg x 18 kgs total) (UPS Worldwide Expedited (billed dimensional weight 18 KGS)):', 'S$185.48', 185.4800, 'ot_shipping', 2), (229, 76, 'Total:', '<b>S$1,340.48</b>', 1340.4800, 'ot_total', 4), (230, 77, 'Sub-Total:', 'S$392.00', 392.0000, 'ot_subtotal', 1), (231, 77, 'United Parcel Service (1 pkg x 6 kgs total) (UPS Worldwide Expedited (billed dimensional weight 6 KGS)):', 'S$107.62', 107.6200, 'ot_shipping', 2), (232, 77, 'Total:', '<b>S$499.62</b>', 499.6200, 'ot_total', 4), (239, 81, 'Sub-Total:', 'S$392.00', 392.0000, 'ot_subtotal', 1), (240, 81, 'Total:', '<b>S$392.00</b>', 392.0000, 'ot_total', 4), (241, 82, 'Sub-Total:', 'S$392.00', 392.0000, 'ot_subtotal', 1), (242, 82, 'Total:', '<b>S$392.00</b>', 392.0000, 'ot_total', 4), (243, 83, 'Sub-Total:', 'S$784.00', 784.0000, 'ot_subtotal', 1), (244, 83, 'Local (Ex Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2), (245, 83, 'FL TAX 7.0%:', 'S$54.88', 54.8800, 'ot_tax', 3), (246, 83, 'Total:', '<b>S$838.88</b>', 838.8800, 'ot_total', 4), (247, 84, 'Sub-Total:', 'S$784.00', 784.0000, 'ot_subtotal', 1), (248, 84, 'Local (Ex Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2), (249, 84, 'FL TAX 7.0%:', 'S$54.88', 54.8800, 'ot_tax', 3), (250, 84, 'Total:', '<b>S$838.88</b>', 838.8800, 'ot_total', 4), (257, 87, 'Sub-Total:', 'S$385.00', 385.0000, 'ot_subtotal', 1), (258, 87, 'Courier (UPS):', 'S$0.00', 0.0000, 'ot_shipping', 2), (259, 87, 'Total:', '<b>S$385.00</b>', 385.0000, 'ot_total', 4), (260, 88, 'Sub-Total:', 'S$385.00', 385.0000, 'ot_subtotal', 1), (261, 88, 'Courier (UPS):', 'S$0.00', 0.0000, 'ot_shipping', 2), (262, 88, 'Total:', '<b>S$385.00</b>', 385.0000, 'ot_total', 4), (271, 91, 'Sub-Total:', 'S$392.00', 392.0000, 'ot_subtotal', 1), (272, 91, 'Local (Ex Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2), (273, 91, 'FL TAX 7.0%:', 'S$27.44', 27.4400, 'ot_tax', 3), (274, 91, 'Total:', '<b>S$419.44</b>', 419.4400, 'ot_total', 4), (277, 93, 'Sub-Total:', 'S$0.00', 0.0000, 'ot_subtotal', 1), (278, 93, 'Local (Ex Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2), (279, 93, 'Total:', '<b>S$0.00</b>', 0.0000, 'ot_total', 4), (280, 94, 'Sub-Total:', 'S$0.00', 0.0000, 'ot_subtotal', 1), (281, 94, 'Local (Ex Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2), (282, 94, 'Total:', '<b>S$0.00</b>', 0.0000, 'ot_total', 4), (283, 95, 'Sub-Total:', 'S$0.00', 0.0000, 'ot_subtotal', 1), (284, 95, 'Local (Ex Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2), (285, 95, 'Total:', '<b>S$0.00</b>', 0.0000, 'ot_total', 4), (292, 98, 'Sub-Total:', 'S$0.00', 0.0000, 'ot_subtotal', 1), (293, 98, 'Local (Ex Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2), (294, 98, 'Total:', '<b>S$0.00</b>', 0.0000, 'ot_total', 4), (295, 99, 'Sub-Total:', 'S$0.00', 0.0000, 'ot_subtotal', 1), (296, 99, 'Local (Ex Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2), (297, 99, 'Total:', '<b>S$0.00</b>', 0.0000, 'ot_total', 4), (314, 104, 'Sub-Total:', 'S$934.00', 934.0000, 'ot_subtotal', 1), (315, 104, 'Local (Ex Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2), (316, 104, 'FL TAX 7.0%:', 'S$65.38', 65.3800, 'ot_tax', 3), (317, 104, 'Total:', '<b>S$999.38</b>', 999.3800, 'ot_total', 4), (318, 105, 'Sub-Total:', 'S$934.00', 934.0000, 'ot_subtotal', 1), (319, 105, 'Local (Ex Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2), (320, 105, 'FL TAX 7.0%:', 'S$65.38', 65.3800, 'ot_tax', 3), (321, 105, 'Total:', '<b>S$999.38</b>', 999.3800, 'ot_total', 4), (322, 106, 'Sub-Total:', 'S$0.00', 0.0000, 'ot_subtotal', 1), (323, 106, 'Local (Ex Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2), (324, 106, 'Total:', '<b>S$0.00</b>', 0.0000, 'ot_total', 4), (325, 107, 'Sub-Total:', 'S$0.00', 0.0000, 'ot_subtotal', 1), (326, 107, 'Local (Ex Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2), (327, 107, 'Total:', '<b>S$0.00</b>', 0.0000, 'ot_total', 4), (328, 108, 'Sub-Total:', 'S$450.00', 450.0000, 'ot_subtotal', 1), (329, 108, 'Special (Flotech Singapore will call you):', 'S$0.00', 0.0000, 'ot_shipping', 2), (330, 108, 'Total:', '<b>S$450.00</b>', 450.0000, 'ot_total', 4), (331, 109, 'Sub-Total:', 'S$0.00', 0.0000, 'ot_subtotal', 1), (332, 109, 'Sea (Ex Work Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2), (333, 109, 'Total:', '<b>S$0.00</b>', 0.0000, 'ot_total', 4), (334, 110, 'Sub-Total:', 'S$150.00', 150.0000, 'ot_subtotal', 1), (335, 110, 'Special (Flotech Singapore will call you):', 'S$0.00', 0.0000, 'ot_shipping', 2), (336, 110, 'Total:', '<b>S$150.00</b>', 150.0000, 'ot_total', 4), (337, 111, 'Sub-Total:', 'S$150.00', 150.0000, 'ot_subtotal', 1), (338, 111, 'Air (Ex Work Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2), (339, 111, 'Total:', '<b>S$150.00</b>', 150.0000, 'ot_total', 4), (340, 112, 'Sub-Total:', 'S$800.00', 800.0000, 'ot_subtotal', 1), (341, 112, 'Air (Ex Work Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2), (342, 112, 'Total:', '<b>S$800.00</b>', 800.0000, 'ot_total', 4), (343, 113, 'Sub-Total:', 'S$777.00', 777.0000, 'ot_subtotal', 1), (344, 113, 'Air (Ex Work Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2), (345, 113, 'Total:', '<b>S$777.00</b>', 777.0000, 'ot_total', 4), (346, 114, 'Sub-Total:', 'S$770.00', 770.0000, 'ot_subtotal', 1), (347, 114, 'Courier (DHL - <a href="#">click here for pricing calculation</a>):', 'S$0.00', 0.0000, 'ot_shipping', 2), (348, 114, 'Total:', '<b>S$770.00</b>', 770.0000, 'ot_total', 4), (349, 115, 'Sub-Total:', 'S$535.00', 535.0000, 'ot_subtotal', 1), (350, 115, 'Air (Ex Work Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2), (351, 115, 'Total:', '<b>S$535.00</b>', 535.0000, 'ot_total', 4), (352, 116, 'Sub-Total:', 'S$150.00', 150.0000, 'ot_subtotal', 1), (353, 116, 'Sea (Ex Work Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2), (354, 116, 'Total:', '<b>S$150.00</b>', 150.0000, 'ot_total', 4), (355, 117, 'Sub-Total:', 'S$300.00', 300.0000, 'ot_subtotal', 1), (356, 117, 'Air (Ex Work Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2), (357, 117, 'Total:', '<b>S$300.00</b>', 300.0000, 'ot_total', 4), (358, 118, 'Sub-Total:', 'S$392.00', 392.0000, 'ot_subtotal', 1), (359, 118, 'Courier (DHL - <a href="#">click here for pricing calculation</a>):', 'S$0.00', 0.0000, 'ot_shipping', 2), (375, 123, 'Total:', '<b>S$150.00</b>', 150.0000, 'ot_total', 4), (376, 124, 'Sub-Total:', 'S$150.00', 150.0000, 'ot_subtotal', 1), (377, 124, 'Courier (DHL - Pricing: <a href="jumbo.pdf?phpMyAdmin=X%2C-VEfqS0w-%2CHvXUmucZ9lgbRPb&phpMyAdmin=UB3dui0u7P3TwsqdeDyImwGrpS4&phpMyAdmin=f-p9NsQGHzXwuAlzpV8o27R%2CY2f" target="_blank">Jumbo Box</a> | <a href="export.pdf?phpMyAdmin=X%2C-VEfqS0w-%2CHvXUmucZ9lgbRPb&phpMyAdmin=UB3dui0u7P3Twsq',&phpMyAdmin=f-p9NsQGHzXwuAlzpV8o27R%2CY2f 'S$0.00', 0.0000, 'ot_shipping', 2), (378, 124, 'Total:', '<b>S$150.00</b>', 150.0000, 'ot_total', 4), (379, 125, 'Sub-Total:', 'S$200.00', 200.0000, 'ot_subtotal', 1), (380, 125, 'Air (Ex Work Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2), (381, 125, 'Total:', '<b>S$200.00</b>', 200.0000, 'ot_total', 4), (382, 126, 'Sub-Total:', 'S$150.00', 150.0000, 'ot_subtotal', 1), (383, 126, 'Air (Ex Work Singapore):', 'S$0.00', 0.0000, 'ot_shipping', 2), (384, 126, 'Total:', '<b>S$150.00</b>', 150.0000, 'ot_total', 4), (385, 127, 'Sub-Total:', 'S$140.00', 140.0000, 'ot_subtotal', 1), (386, 127, 'Courier (DHL - Ref. Rate: <a href="jumbo.pdf?phpMyAdmin=X%2C-VEfqS0w-%2CHvXUmucZ9lgbRPb&phpMyAdmin=UB3dui0u7P3TwsqdeDyImwGrpS4&phpMyAdmin=f-p9NsQGHzXwuAlzpV8o27R%2CY2f" target="_blank">Jumbo Box</a> | <a href="export.pdf?phpMyAdmin=X%2C-VEfqS0w-%2CHvXUmucZ9lgbRPb&phpMyAdmin=UB3dui0u7P3Tw',&phpMyAdmin=f-p9NsQGHzXwuAlzpV8o27R%2CY2f 'S$0.00', 0.0000, 'ot_shipping', 2), (387, 127, 'Total:', '<b>S$140.00</b>', 140.0000, 'ot_total', 4),
Comment