SQL Statement Debugger

Record::get_records_for_sql()

SELECT
  `tr`.`ID`,
  `tr`.`tax1_rate`,
  `tr`.`tax2_rate`,
  `tr`.`tax3_rate`,
  `tr`.`tax4_rate`,
  `tr`.`tax5_rate`,
  `tr`.`tax6_rate`,
  `tr`.`tax7_rate`,
  `tr`.`tax8_rate`,
  `tr`.`tax9_rate`,
  `tr`.`tax10_rate`,
  `tr`.`tax11_rate`,
  `tr`.`tax12_rate`,
  `tr`.`tax13_rate`,
  `tr`.`tax14_rate`,
  `tr`.`tax15_rate`,
  `tr`.`tax16_rate`,
  `tr`.`tax17_rate`,
  `tr`.`tax18_rate`,
  `tr`.`tax19_rate`,
  `tr`.`tax20_rate`,
  `tz`.`tax1_name`,
  `tz`.`tax2_name`,
  `tz`.`tax3_name`,
  `tz`.`tax4_name`,
  `tz`.`tax5_name`,
  `tz`.`tax6_name`,
  `tz`.`tax7_name`,
  `tz`.`tax8_name`,
  `tz`.`tax9_name`,
  `tz`.`tax10_name`,
  `tz`.`tax11_name`,
  `tz`.`tax12_name`,
  `tz`.`tax13_name`,
  `tz`.`tax14_name`,
  `tz`.`tax15_name`,
  `tz`.`tax16_name`,
  `tz`.`tax17_name`,
  `tz`.`tax18_name`,
  `tz`.`tax19_name`,
  `tz`.`tax20_name`
FROM
  `tax_regime` `tr`
INNER JOIN `tax_zone` `tz` ON
  `tr`.`tax_zoneID` = `tz`.`ID`
WHERE
  `tr`.`ID` IN()

Error:

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 ')' at line 48

Warning: Invalid argument supplied for foreach() in /home/www/ximmix/ximmix_tsm/classes/class.tax_regime.php on line 223

Notice: Undefined variable: tax_regime in /home/www/ximmix/ximmix_tsm/classes/class.custom_form.php on line 387
Signup

Skip to Content

TruckSafetyManager.com
©2008 TruckSafetyManager.com | Site by AuroraOnline Inc | Powered by XiMMiX