New angle??

This message was sent from: Features
http://forums.oscommerce.com/viewtopic.php?p=204847#204847
----------------------------------------------------------------

Not sure if others are still watching this thread, but I have a question/idea.

I am also in Colorado and am trying to reconcile charging tax based on State, County and City.  

What I would like to be able to do to keep it as simple as possible is the following:

[list]
o Add a "new" tax zone in Locations/Taxes->Zones that refers to the city
o Add this tax zone into the Tax Rates section.
o Compare this new "city" tax zone against the entry_city name and decide whether to add to the tax rate..
[/list]
  
The question I have currently is to anyone who understands the code a little better than I do currently.  Where/How in the general.php, assuming that is the correct source file,  would I query the database's zones and match them against the users city then add this to the tax %.

And,  does this seem like a good idea?

I am initially doing the city because that seems straight forward as there is an entry in the db for the city.  The county will be a little harder as more code will needed to moded, but I believe it could be worth the effort.  

I am faily new to PHP, mysql and to oscommerce, but am trying to learn.

Thanks for any help!