select * where date is between

[flemingmike]

hi, what is the proper way to to

 

$now

$next tuesday

 

select * where date is between now and next tuesday

 

thx all

[voip03]

SELECT * FROM `DB_table` WHERE date BETWEEN '2011-09-01' AND '2011-09-10' 

There are tons of examples if you search Google.

[flemingmike]

perfect.  is there a way to write next tuesday?

 

$nexttuesday=date('Y-m-d g:i A', strtotime("tuesday") );

[funstein]

strtotime("next Thursday");

 

That should do it.

[skwap]

i think this is you need to get

// today date.
$today = date('Y-m-d');

//next tuesday date.
$next = date('Y-m-d', strtotime("tuesday"));

//query to get the records between today & next tuesday.
$sql = "SELECT * FROM `DB_table` WHERE date BETWEEN '$today' AND '$next'";