Date: 10/15/08 (MySQL Communtiy)    Keywords: no keywords

Is there a way to select a series of Sundays, based on any given date?

To clarify... A start date is submitted so I'd first need to find the next Sunday (if the start date didn't already start on Sunday). Then I can determine the following Sundays easily enough. The trick is finding the very next Sunday from my start date.

Ideas?

Source: http://community.livejournal.com/mysql/131930.html