PDA

View Full Version : need help in getting the equivalent month of week



newphpbees
13 Aug 2012, 12:56 AM
Hi..

I have 2 tables for week and calendar days.

first I have so_week
fields:
from_week
to_week

second is calendar_days
fields:
month_name
working_days

sample data:
from_week : 33
to_week: 36

month_name:
Jan
Feb
Mar
Apr
May
and so on

working_days:
23
22
25
25
23

now I need to get the working days based on from_week to week

for example from 33 to 36 the month is aug, sep, sep, sep i need to get the working days for that month.

any help is highly appreciated..

Thank you so much