Retrieving product taxes

[MrBaseball34]

How would I retrieve the taxes for a product in this format:

US:TX:8.25

[rocky]

I don't have state taxes set up, so I can't test this, but try this:

$result = Db::getInstance()->ExecuteS('SELECT c.`iso_code` AS `country_iso_code`, s.`iso_code` AS `state_iso_code`, t.`rate` FROM `'._DB_PREFIX_.'tax` t LEFT JOIN `'._DB_PREFIX_.'_tax_state` ts ON (t.`id_tax` = ts.`id_tax`) LEFT JOIN `'._DB_PREFIX_.'_state` s ON (ts.`id_state` = s.`id_state`) LEFT JOIN `'._DB_PREFIX_.'_country` c ON (c.`id_country` = s.`id_country`)');

foreach ($result as $row)
  echo $row['country_iso_code'].':'.$row['state_iso_code'].':'.$row['rate']."\n";

[MrBaseball34]

Works great. This is for the modifications I'm making to the googlebase feed module. I hope to have it ready soon.