This is not as easy (conceptually) as it sounds. You have to know the current state tax plus any county taxes applicable. If you set up a table with this information, you can cross reference the location of the buyer with the table, calculate the appropriate taxes, and charge them accordingly. You must also make sure to record the taxes that were paid so they can be paid to the appropriate tax agency. Not an easy task. There are sources out there for all of this information and you can get tax tables on a CD that can be imported. Brady... ----Original Message Follows---- From: Mikel King <[EMAIL PROTECTED]> To: LDL Enterprise <[EMAIL PROTECTED]> CC: *MySQL mail list <[EMAIL PROTECTED]> Subject: Re: taxes Date: Wed, 14 Feb 2001 16:57:35 -0500 Wound't you just set a table with an id, state_abrev, & tax columns. Then the id column will match the selection...et cettera...capisce LDL Enterprise wrote: > does anyone know how to calculateg taxes for a shop cart that would set the > tax depending on the state that they select when filling out their contact > information? Thanks. > > _ __ _ > | | | \ | | > | |__ | |> || |__ > |____||___/ |____| > > Larry L. > [EMAIL PROTECTED] > www.ldlenterprise.com > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
