Link to home
Start Free TrialLog in
Avatar of adrake9
adrake9

asked on

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.
-a
$week_query = ("SELECT * from timecard_data
		WHERE WEEK(CURDATE()) = WEEK(job_date) 
		AND emp_id = '$emp';");

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Sebastian Talmon
Sebastian Talmon
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of adrake9
adrake9

ASKER

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?