Help with PHP/mySQL problem.

[ow-phil]

I am working on a site which does deliveries for items based on the days associated with the items.

Each Item has been assigned a number (1 for Sunday, 2 for Monday... etc).

All items that are ordered for Monday or Tuesday are Delivered on Sunday (2 & 3)

All items ordered for Wednesday and Thursday are delivered on Tuesday (4&5)

All Items ordered for Friday, Saturday and Sunday are delivered on Thursday (6,7,1)

For each delivery day, there is a charge of $5.00 (one time charge for each day).

I need something to check against the DB to see what Items are ordered, and if an item is ordered for a delivery date, it will add the charge to the Delivery Charge. But only one for each of the delivery dates.

Any thoughts on this. As I am stumped.

Thanks in advance,

Phil

[dalecosp]

I may be stoopid ... if each item gets delivered, add $5.00 to each item?