Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New Coder
    Join Date
    Aug 2011
    Posts
    25
    Thanks
    5
    Thanked 0 Times in 0 Posts

    what's the error here in sql syntax

    i tried to transferred the sql database from remote to local and then i got this error message

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

  • #2
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,633
    Thanks
    4
    Thanked 148 Times in 139 Posts
    You've already posted the same question here:
    sql syntax error

    please don't double post.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •