close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Adding Delivery Charges

Thread began 1/02/2011 2:28 pm by elewis93815 | Last modified 1/11/2011 10:36 am by elewis93815 | 3529 views | 34 replies


Originally Said By: Jason Byrnes
  the value passed from the checkout page is note the selected city, it looks like it is the actual delivery fee?

<select name="DeliveryCity" id="DeliveryCity">
<option value="15.00">Downtown Mpls</option>
<option value="15.00">Downtown Saint Paul</option>
<option value="15.00">Roseville</option>
<option value="15.00">Falcon Heights</option>
<option value="25.00">West Saint Paul</option>
<option value="25.00">South Saint Paul</option>
<option value="25.00">Maplewood</option>
<option value="25.00">New Brighton</option>
<option value="25.00">Shoreview</option>
<option value="25.00">Fridley</option>
<option value="25.00">Golden Valley</option>
<option value="25.00">Mendota Heights</option>
<option value="25.00">Robbinsdale</option>
<option value="25.00">Hopkins</option>
<option value="25.00">Edina</option>
<option value="25.00">Saint Louis Park</option>
<option value="25.00">Richfield</option>
<option value="35.00">New Hope</option>
<option value="35.00">Mahtomedi</option>
<option value="35.00">Woodbury</option>
<option value="35.00">Plymouth</option>
<option value="35.00">Brooklyn Park</option>
<option value="35.00">Brooklyn Center</option>
<option value="35.00">Bloomington</option>
<option value="35.00">Circle Pines</option>
<option value="35.00">White Bear Lake</option>
<option value="35.00">Hugo</option>
<option value="40.00">Maple Grove</option>
<option value="40.00">Anoka</option>
<option value="40.00">Blaine</option>
<option value="40.00">Coon Rapids</option>
<option value="40.00">Ham Lake</option>
<option value="40.00">Eagan</option>
<option value="40.00">Burnsville</option>
<option value="40.00">Eden Prairie</option>
<option value="40.00">Minnetonka</option>
<option value="40.00">Wayzata</option>
<option value="40.00">Inver Grove Heights</option>
<option value="40.00">Minnetrista</option>
<option value="50.00">Cottage Grove </option>
<option value="50.00">Apple Valley</option>
<option value="50.00">Hastings</option>
<option value="50.00">Stillwater</option>
<option value="50.00">Chanhassen</option>
<option value="50.00">Chaska</option>
<option value="50.00">Shakopee</option>
<option value="50.00">Forest Lake</option>

rays initial advice was to use the data base to populate the list, then use a recordset to lookup the delivery rate

the reason for doing it this way is that you probably want to show the selected delivery city, right? if the valuer in the select list is the delivery fee, there is no way to show what the delivery city selected is.

the delivery fee is not working because the recordset is filtering on the value posted by the select list. In this case the delivery fee, it s comparing the fee "15" to the city name column in the database. In other words, comparing apples to oranges.  

Your absolutely right! We are trying to show that the city selected has a delivery fee "X" associated with it therefore creating a delivery charge for the selected city.

It sounds like I have the filter in the recordset wrong??? I've attached a screen shot of the recordset.

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.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question





Ease of use


security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...