Hey all, I have an SQL query that's stumping me.
I have two date variables, $start and $end that are in mm/dd/yyyy format and two database fields, start_date and no_donations. The start date is mm/dd/yyyy format and no_donations is an integer that represents the number of months from start_date that donations will be made.
So if start date is say 02/01/2010 and no_dations is 4 then donations will be made four times from the start date for four months.
What I need to do is come up with a query that will determine if the start_date + no_donations falls within $start and $end.
But I'm pretty stumped. How can I convert start_date + no_donations in the database to the date when the last donation will take place so I'll now if the donations fall between $start and $end?
Any suggestions would be very help and appreciated, Skip -- ==================================== Skip Evans PenguinSites.com, LLC 503 S Baldwin St, #1 Madison WI 53703 608.250.2720 http://penguinsites.com ------------------------------------ Those of you who believe in telekinesis, raise my hand. -- Kurt Vonnegut -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
