Custom Shipping from database

I've setup country and state / province in my db with a shipping premium so that they each have a base rate for orders to that region.

I started with a simple Flat Rate amount to get it working initially. That's all fine.

Now I want to substitute my flat rate of .02 with the value from the db.

//eCart Rule

function WAEC_eCart1_Country()  {

  $totalShipping = 0;

  if (true && ((sizeof($this->Items) > 0) && (isset($_SESSION['eCartCheckoutForm_country'])))) {

    $totalShipping +=  '".$row_shipcountry['ShipPremium']."';//Result

  }

  return WA_eCart_FormatNumber($totalShipping, $this->ForceDecimalsC, $this->DecimalPlacesC);

}

//eCart Rule

{

This is in eCart1.php
Recordset shipcountry is on confirm.php. Session values and Recordset works fine.

My problem is syntax.
I get:
Parse error: syntax error, unexpected T_STRING in C:\Inetpub\vhosts\drjacknewman.com\httpdocs\2011\WA_eCart\eCart1_PHP.php on line 99

Line 99 is of course the line that includes:
'".$row_shipcountry['ShipPremium']."'

i have also tried <?php echo $row_shipcountry['ShipPremium']; ?> with a similar type of error.

Please help if you can.
Thanks,

change:

$totalShipping +=  '".$row_shipcountry['ShipPremium']."';//Result

to:

$totalShipping += "".$row_shipcountry['ShipPremium']."";//Result

Thank you.

That eliminated my error, but the amount is not being added to my shipping value so I still have some work to do.

I've placed the premiums on the page so that I can see that they are correct so that's not it.

Perhaps I should be doing this with the calculations tab.

try storing the ShipPremium amount from the recordset into a session variable and using the session variable value in the charge rule instead of the recordset value.

OK,
So I setup the Session Value on the confirm page, trigger is if rs is not empty.

then I changed the shipping calc to this on eCart1.php

//eCart Rule

function WAEC_eCart1_Country()  {

  $totalShipping = 0;

  if (true && ((sizeof($this->Items) > 0) && (isset($_SESSION['eCartCheckoutForm_country'])))) {

$totalShipping += "".$SESSION['shipcountry']."";//Result  

}

  return WA_eCart_FormatNumber($totalShipping, $this->ForceDecimalsC, $this->DecimalPlacesC);

}

//eCart Rule

No errors. Session Values are correct, but still no shipping amount.

Seems like it is still a Syntax issue, in getting that value to register as a number.

Since I now have the number I need in a Session Value I simplified the shipping rule to:

//eCart Rule

function WAEC_eCart1_Country()  {

  $totalShipping = 0;

  if (true && ((sizeof($this->Items) > 0) && ((isset($_SESSION['shipcountry'])?$_SESSION['shipcountry']:"") > "0"))) {

    $totalShipping += "".$SESSION['shipcountry']."";//Result

  }

  return WA_eCart_FormatNumber($totalShipping, $this->ForceDecimalsC, $this->DecimalPlacesC);

}

//eCart Rule

but it still ignores it.

Just to check, I substituted

"".$SESSION['shipcountry'].""

with 10, and the rule works fine, adding $10.00.

Has to be syntax.

This worked.

//eCart Rule

function WAEC_eCart1_Country()  {

  $totalShipping = 0;

  if (true && ((sizeof($this->Items) > 0) && ((isset($_SESSION['shipcountry'])?$_SESSION['shipcountry']:"") > "0"))) {

    $totalShipping += $_SESSION['shipcountry'];//Result

  }

  return WA_eCart_FormatNumber($totalShipping, $this->ForceDecimalsC, $this->DecimalPlacesC);

}

//eCart Rule

Thank you for your assistance. Hope this helps someone else.

Key was getting a Session Variable with the number I needed.