Guest Posted August 30, 2006 Share Posted August 30, 2006 I'm trying to get the sales tax added in my new store, but while doing so I find this error when clicking on any tax zone. I am new to MySQL (and php) and have no idea where to take it from here. Any help much appreciated! Tax Zones Country Zone Action 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 '-20, 20' at line 1 select a.association_id, a.zone_country_id, c.countries_name, a.zone_id, a.geo_zone_id, a.last_modified, a.date_added, z.zone_name from zones_to_geo_zones a left join countries c on a.zone_country_id = c.countries_id left join zones z on a.zone_id = z.zone_id where a.geo_zone_id = 2 order by association_id limit -20, 20 Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.