MySQL - PHP output shipping table

rayzun posted this at 22:18 — 18th December 2005.

Joined: Feb 2005

Anyone could help me with a query to my table to output a shipping table / rate / based on current day.

(product)
ITEM FRI SAT MON TUE WED THU

IF200 8.95 8.95 8.95 8.95 8.95 8.95
IF700 2.95 2.95 2.95 2.95 2.95 4.95
...
Above is my most basic table with the cost of shipping for a item for any given day.

Im looking to query table "product" for the item first, then in a rolling fashion
show the rate for that day - starting from the current day
E.G.
If today was WEDNESDAY:
WED 8.95
THU 8.95
FRI 8.95

The end result will also have the result in calendar format

E.G.
If today was WEDNESDAY, DECEMBER 21:
DECEMBER 21 WED - $8.95
DECEMBER 22 THU - $8.95
DECEMBER 23 FRI - $8.95

I could make different tables and cross-query type stuff, BUT
anyone who has had experience in building such a database...
suggestions are really needed??