PHP & MYSQL: Closest Dates

dcgamers · Sep 10, 2006

How would I display all the data in a table where the date field is within 10 days above the current date? Im tring to display all dates within the next 10 days. How can I do that with php & mysql?

NuPagady · Sep 10, 2006

So basicly you need to know two variables: today's date and date after 10 days.

Try adding this to WHERE clause:

Code:

... WHERE date > ADDDATE(CURRENT_DATE(), 0) AND date <= ADDDATE(CURRENT_DATE() , 10)

'date' is your date field.

Another way would be something like that:

Code:

$tendays = 60*60*24*10 // how many seconds in 10 days
$datenow = date("Y-m-d");
$date10 = date("Y-m-d", time() + $tendays); // this will be your date (10 days after)

Change Y-m-d to your date format. You can find information on how to do that here:
http://www.php.net/date
Then put date variables to your WHERE clause. Something like: ... WHERE date > $datenow and date <= $date10

I haven't checked the code for errors, I just wrote it. I hope this will be enough to get a general idea

Good luck!

PHP & MYSQL: Closest Dates

Established Member

Established Member

Parcelex.com

Nimble.org

socialsms.com

hondabigwing.com

DharmaGroup.com

CodeConnect.com

0.VG

GSWO.Com

A.chat

Digi.co

Similar threads

We're social

Parcelex.com

Nimble.org

socialsms.com

hondabigwing.com

DharmaGroup.com

CodeConnect.com

0.VG

GSWO.Com

A.chat

Digi.co

Pinned

Appreciation

Preference

Appreciation

Upvoting

Agreement

Answers

Decisions

Relevance

Reaction

Facial expressions

Vocal expressions

Status

Workflow

Clarification

Feeling

Sympathy