datetime manipulation

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
I have an id in mySQL server with format dateStart DATETIME (// YYYY-

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.

Re: datetime manipulation

Slickuser wrote:
Quoted text here. Click to load it

It's best to do the sorting in MySQL.  Try asking in comp.databases.mysql.

Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.

Re: datetime manipulation

Quoted text here. Click to load it

That sentence doesn't make sense.  It's certainly possible to sort a table
by date, but you can't sort a table by "today".

Are you trying to select records between two dates?
Tim Roberts,
Providenza & Boekelheide, Inc.

Site Timeline