SQL CODE TO Request all Entrys Created in this Week

[Anonymous]

Maybe more like:

SELECT *
FROM   main
WHERE  date >= {DATE} // start week
AND    date <= {DATE} // end week
;

 

[Anonymous]

Use strtotime() function and its combinations.

 

[Anonymous]

Hi,

I'd rather use:

SELECT * FROM main WHERE date_start<=NOW() AND date_end>=NOW()";

Using mysql built-in functions is faster.

Cheers.