Help with query structure, upcoming events and birthdays (two separate tables)

[eluser]slowgary[/eluser]
Is there anything specific that you're having problems with? Asking a specific question usually garners more answers since, as it stands, I'm not really sure what to help with.

One helpful function would be PHP's strtotime(), which will let you replace this:

Code:

$this_week = date("Y-m-d H:i", mktime(date("H"),date("i"),0,date("m"),date("d")+$daystoadd,date("Y")));

with this:

Code:

$this_week = date('Y-m-d H:i', strtotime('+1 week'));