[Webinar] Streamline your web hosting managementRegister Today

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 288
  • Last Modified:

How to increment through records on a weekly basis

I have results for a weekly time sheet that I have dynamically generated on a page. What i want to do is to be able to navigate through these records on a weekly basis. the code below is the query i use to generate the results. My question is...Is it possible to create a variable that would go forward or back in one week increments?

Is this done in the query? or do i need to set up some php variables that accomplish this and use them in the query? any help is appreciated.
$week_query = ("SELECT * from timecard_data
		WHERE WEEK(CURDATE()) = WEEK(job_date) 
		AND emp_id = '$emp';");

Open in new window

1 Solution
Sebastian TalmonSystem Engineer Datacenter SolutionsCommented:

you should have an additional variable containing the offset in weeks from now, for example  $_GET['weekoffset']

you could specify the offset in the URL / Link as  xxx.php?weekoffset=23

$week_query = ("SELECT * from timecard_data
            WHERE WEEK(DATE_SUB(CURDATE(), ".(int)$_GET['weekoffset']." WEEKS)) = WEEK(job_date)
            AND emp_id = '$emp';");
adrake9Author Commented:
so if i had a next/previous button on my site I could make the weekoffset=1 or -1 and get the previous or next week?

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now