How to search data based on the next Sunday of the week

Question

I need to find a row of data from MySQL based on next Sunday of the week. Does anyone know how?

+2

sman591 May 16 '10 at 18:33

1 answer

Rabbott · Accepted Answer · 2010-05-16T18:36:24+0000

you can define next Sunday using PHP, then pass that in your request.

$nextSunday = date("Y-m-d", strtotime('next sunday'));

if you need next Sunday from a certain date

$date = strtotime('2010-07-01');
$nextSunday = date("Y-m-d", strtotime('next sunday', $date));

Provide this date to your request

$result = mysql_query("SELECT * FROM table WHERE date = '$date'")