Days of week

Hi - is there anyway I can change the status of server listings according to the days of the week.

1 = Monday
2 = Teusday
3 = Wednesday
4 = Thursday
5 = Friday
6 = Saturday
7 = Sunday

Using the following data structure:

id | server | days

1 | a | 1
2 | a | 2
3 | a | 3
4 | b | 4
5 | b | 5
6 | a | 6
7 | c | 7

So in a php script it retrieves the current day (1,2,3,4,5,6,7) and then looks in the table for that day?

Thanks,

Chris

im not clear what it is that you want ??

u want to change

1 | a | 1
2 | a | 2
3 | a | 3
4 | b | 4
5 | b | 5
6 | a | 6
7 | c | 7

1 | a | Monday
2 | a | Tuesday
3 | a | Wednesday
4 | b | Thursday
5 | b | Friday
6 | a | Saturday
7 | c | Sunday

reg
kevin

Looking back I could've written it in a few lines.

What I'm looking for is a way to get the script to find the correct date, assign it the correct number then find that number in the database.

The database bit is easy but I'm lost on the date. 😐

Thanks in advance,

Chris

[man]date[/man]

Hey thanks! I been sifting through for ages, not looking in the right direction though.

Thanks,

Chris