Pros! help with simple navigating through records...

brianb

hello pros,

Please help. Any coding examples are deeply appreciated.

I have a system setup to browse through entries in my MySQL database by WEEK. I am trying to create a navigation system to run through the WEEKS of the year but am having no luck.

Here's what my code looks like for the navigation.

$yearWeek = date('YW');

$prevYW = date( 'YW', strtotime(($yearWeek-1).'01') );
$nextYW = date( 'YW', strtotime(($yearWeek-1).'01') );

What am I doing wrong? When I call my $prevYW and $nextYW my numbers come up like so:

$nextYW = 20065
$nextYW = 20065

Thanks in advance!

Weedpacket

You do realise that you can say strtotime('next week') and strtotime('last week'), don't you?

brianb

Crap...

That's not working either.

Any other ideas?

Weedpacket

What,
$prevYW = date( 'YW', strtotime('last week'));
doesn't work?

Do you know what a timestamp is? The number of seconds that have elapsed since the start of 1970? Why are you effectively multiplying that by a hundred and adding 1 to get "next week"?

brianb

I don't understand. I need examples on how to do this right if you're telling me I'm wrong.

Thanks.

Weedpacket

I just gave you an example. Which bit don't you understand?

Weedpacket

I just gave you an example. Which bit don't you understand? The code you wrote? I have to say I don't understand it.

brianb

Hi again,

Ok...maybe I should start this from scratch...

Like I said before, I just want to be able to move forward ONE WEEK or backward ONE WEEK from whatever WEEK I've called...

Of course, being that there is NOT 53 weeks in a year, the PHP has to recognize this and switch the year when navigating as well.

Where would you start if you were me? I'm confused now.

Any coding example are appreciated!

Thanks.

Weedpacket

Well the time (in Year-Weeknumber format) right now is date('YW');

The time (in Year-Weeknumber format) at the same time next week is date('YW',strtotime('next week'));

In other words, that's where I start and end.

What did you get when you tried that code? You did try it, didn't you?

Duey

lol, ive never seen Weedpacket so frustrated. Ahh well all the help he gives out who wouldnt be! good on ya Weedpacket. question for you, how many programming languages do you know.