Slickuser wrote:
> I have an id in mySQL server with format dateStart DATETIME (// YYYY-
> MM-DD HH:MM:SS)
>
> Now I want to sort the table by today and 1 week starting from now.
> $today = date("Y-m-d h:i:s");
>
> I am not sure how to achieve that, any help? thank you.

google mysql date and read the docs. they are replete with examples on
date time manipulation.