php - How to lookup data based on the next sunday of the week -

I need to see a line of data from MySQL based on the next Sunday of the week. How do anyone know?

You can set the next Sunday using PHP, then pass it in your query.

ex> $ Agustanai = date ("YMD", strotome ('next Sunday'));

If you need a Sunday from a certain date

  $ date = strtotime ('2010-07-01'); $ Agelessness = Date ("Y-M-D", Strottomman ('Next Sunday', $ date));  

Provide this date to your query

  $ result = mysql_query ("Select from * date to date = '$ date'")