Pagination based on week number

[chrisguk]

Hi All,

I am trying to figure out a solution that does the following:

1. At the top of a page you have links that display week numbers e.g 1 -52

2. When you click on any particular link it displays the content of that row in the database based on the "id" selected.

3. The page this links are on needs to be static and the content displayed dynamically. I was thinking pagination but not too sure.

Using PHP and MySQL I cannot figure out how to start this or what to search for in order to learn how to achieve my goal. I am not asking for you guys to write a complete solution for me but just to give me the detailed advice on how I can achieve my goal.

The data that will be displayed is a weekly menu. So If the user clicks the link Week 5, the following information will be displayed below:

Monday - Soap
Tuesday - potatoes
Wednesday - Soap
Thursday - Chips
Friday - Eggs

The days of the week can be static content and only the food displayed is the stuff pulled from the database.

Thanks in advance for any help

[sneakyimp]

When you say "the user clicks the link Week 5" then you are suggesting a url is needed which tells your server the user is interested in week 5. So a link like this:

<a href="mypage.php?week=5">Week 5</a>

Would take the user to mypage.php where you could extract the week requested like so:

echo "You have requested " . intval($_GET["week"]);

To show a series of links, you could do something like this:

for($w=1; $w<=52; $w++) {
  echo '<a href="mypage.php?week=" . $w . '">' . $w . '</a>';
}

Perhaps if you start your script with this information, we can supply more detail when you get confused.