...

View Full Version : what's the error here in sql syntax



scott_white85
09-13-2011, 01:59 AM
i tried to transferred the sql database from remote to local and then i got this error message



-- -- 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





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),

guelphdad
09-13-2011, 08:43 PM
You've already posted the same question here:
http://www.codingforums.com/showthread.php?t=237676

please don't double post.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum