Help us test the new Databridge BETA with MySQLi support

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › eCart › eCart General / Announcements › Adding delivery locations and fees to an existing set up

View all replies to this thread

Adding delivery locations and fees to an existing set up

Thread began 7/12/2013 3:46 pm by elewis93815 | Last modified 7/12/2013 4:07 pm by elewis93815 | 117 views | 1 replies

7/12/2013 4:07 pmJason ByrnesWebAssist

it looks like you are using the delivery_fee of the location table:

$colname_rsDeliveryFee = "-1";
if (isset($_POST['DeliveryCity'])) {
$colname_rsDeliveryFee = (get_magic_quotes_gpc()) ? $_POST['DeliveryCity'] : addslashes($_POST['DeliveryCity']);
}
mysql_select_db($database_cupcakes, $cupcakes);
$query_rsDeliveryFee = sprintf("SELECT * FROM delivery_fee WHERE location = %s", GetSQLValueString($colname_rsDeliveryFee, "text"));
$rsDeliveryFee = mysql_query($query_rsDeliveryFee, $cupcakes) or die(mysql_error());
$row_rsDeliveryFee = mysql_fetch_assoc($rsDeliveryFee);
$totalRows_rsDeliveryFee = mysql_num_rows($rsDeliveryFee);

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.