[Resolved] Join with dates

[PurpleMonkey]

Ok I'm using a join query to select the dates, names, and course title from two tables. I want to be able to show the courses that people in my database are going on in the next week. I have the query itself working, but I am unsure as to how to get the date in a weeks time. So:

$sql = "select staff.first_name, staff.second_name, courses.course_title from staff,courses where staff.staff_id = courses.staff_id and courses.start_date >= \"".date("Y-m-d")."\" and courses.end_date <= \"".$what_goes_here?."\"";

Notes: Both start_date and end_date are MySQL date fields and staff_id is the PK in the table staff and a FK in coureses.

Thanks, P.M.

[Stelf]

date("Y-m-d", mktime(1, 1, 1, date("m"), date("d") + 7, date("Y")))

Or the way I did it was:

$today = getdate();

Then populated the mktime command with $today['year'], $today['mon'], $today['mday'] (day of the month)

[PurpleMonkey]

Thanks. Does the baove take into account if the day is more than 31, so 29 + 7 = 05 not 36? and the same for month and year?

[Stelf]

Yes. The output would be 05 and plus one month.

I wrote a whole holiday management system using these commands, they work really well.

[PurpleMonkey]

I just tested the new code, and it works perfectly. Thanks for your help Stelf!