Shipping cost table?

n00854180t

I have a problem. I need to put a shipping cost table into a database, and depending on what country and how many ounces of product are selected, take a price from the table.

The table looks like this:

Oz.-----Time Zone 1-----Time Zone 2-----Time Zone 3
8--------20-----------------40-----------------60
16------40-----------------60-----------------80
32------60-----------------80-----------------100
48------80-----------------100---------------120

Except of course the numbers are not so clean cut. Is there any way to do this? I can't write that many conditional statements, nor to I want to 😛

Thanks in advance.

vallette

Do something like this:

//This will round it up to the next multiple of 8; i.e., 11oz would use the 16oz rate
$lookupweight=(ceil($weight/8))*8

//As I understand it the column names are the timezone names so you need to pass the column name you want to look in--I'm using $timezone
$query="SELECT $timezone WHERE Oz=$lookupweight";

You might want to restructure you table like this:

weight
timezone
cost

then your query would look like this:
SELECT cost WHERE weight=$lookupweight AND timezzone='$timezone'

Hope this helps,
Dave

bastien

table should look like this

id
weight
timezone
cost

then its simple to say

select * from table where weight=$weight and tz=$timezone

hth

n00854180t

I can see how that would work. Thanks! I have one more problem though.

I have a select box for the different countries (a lot of them). How can I make it so that if a certain country is selected the corresponding timezone is put in a hidden textbox? There are too many countries to use conditionals. Thanks again!

n00854180t

I also have another problem, I have several different shipping tables. Some of them do not increment the weight by 8 or by any number, they just have say for instance 1, 2, 3, 4, 5, 6, 7, 8, 12, 16, 20 ect. How would I make it round to the next highest weight?

n00854180t

Thanks in advance.

bastien

no need to place the corresponding timezone in the boxes value...you will probably need that for shipping...the trick here is to use arrays....yes the initial set up is some work but the results and speed make up for it...

note: this is all server side code, do this clientside when its so easy on the server

you need to create 24 arrays (1 for each time zone, what are you doing about countries that straddle time zones (ie england has 2, china, austraila etc)?)[/red]

then simply look for the value of you country in the array with the in_array() function using a simple loop

//set the arrays for countries a thru h
[b]$tz1=("ca","cb","cc","cd");
$tz2=("ce","cf","cg","ch");[/b]

//assume user select country e from list (value="ce")
//variable called $country

//create counter to move thru arrays
[b]for ($i=1; $i<=24; $i++){[/b]

  //check if value in array
[b]  if (in_array($country,$tz[$i]){[/b]

  //set timezone value if value is in array
 [b] $timezone=$i;

   }//end if
}//end for loop[/b]

the weight is a more interesting problem...the best bet here is to place the weight for the item in the product description table and extend that(item * quantity) and total that amount up to get to your total weight for the shipment...

you could use another array here which has all the possibilities and then:
1. check for an in_array of yes (the value exists) then run a query to get the total price for shipping
2. if no match then step thru the array comparing one value at a time until the total weigth is less that the next element in the array...that element is the weight used for pricing the shipping

hth