If you create a shipping table you can add a recordset that filters and returns the correct shipping charge on the confirm_cart.php page.
Then store the value returned by the Recordset as a session variable. The rule in the cart can then just charge the amount stored in that session variable when that session variable is defined.