PHP & MYSQL: Closest Dates

dcgamers · 09-10-2006, 11:38 AM

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 · 09-10-2006, 11:56 AM

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:
????: NamePros.com http://www.namepros.com/programming/236606-php-and-mysql-closest-dates.html
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!

09-10-2006, 11:38 AM	THREAD STARTER #1 (permalink)
dcgamers NamePros Member Join Date: Feb 2006 Location: NY, USA, Earth Posts: 85	PHP & MYSQL: Closest Dates 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? __________________ GamerDay - Gaming news, previews, reviews DirectCheat - All the greatest hard to find gaming cheats! VgBox - All the gaming news, reviews, previews from all over the net! Qubble - Tired of Myspace? Join and get unlimited pics on your free profile!

09-10-2006, 11:56 AM	#2 (permalink)
NuPagady NamePros Regular Join Date: Jul 2005 Posts: 483	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 = 60602410 // 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: ????: NamePros.com http://www.namepros.com/programming/236606-php-and-mysql-closest-dates.html 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! Last edited by NuPagady; 09-10-2006 at 12:16 PM.*

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)