How Can I Print-Echo Data Between Dates Only

[just me and php]

Hi I Have A Colum In Datebase That Is date And I Would Like To Only Print/Echo A Weeks Worth Of Data.
The date Colum format is 12/17/06 22:46:16. ( Echo 12/10/06 23:59:59 to 12/17/06 23:59:59 )
Can Somebody Help Me With This Code .
Thanks

[just me and php]

Ok I Found This In Your Forums And I Think Its What Im Looking For But I Dont Under Stand How It Knows What Is The Start Or End Date.[url=http://www.phpfreaks.com/forums/index.php/topic,106961.0.html]http://www.phpfreaks.com/forums/index.php/topic,106961.0.html[/url]

[craygo]

just set it in the sql

[code]$sql = "SELECT * FROM table rec_date BETWEEN DATE '2006-02-01' AND DATE '2006-02-14'";[/code]

Ray

[just me and php]

Thanks Ray That Looks To Easy lol , Il Give It A Try Thanks Again.
Ray <--Also

[just me and php]

Well I Tryed A Few Different Way Bet Get Error, How Can I Use This In My Code?
[code]$query = "SELECT * FROM NatHotLap  BETWEEN date '12/10/06 22:46:16' AND date '12/17/06 22:46:16'";
=================
And I Tryed This Way

$query = "SELECT recno,disp,track,Username,date,online,hacked, MIN(HL_MS) AS HL_MS,reshack FROM NatHotLap  BETWEEN date '12/10/06 22:46:16' AND date '12/17/06 22:46:16'  ORDER BY 'HL_MS' ASC  ";
=================
This Is My Code

$p_id = $_GET['id'];
$query = "SELECT recno,disp,track,Username,date,online,hacked, MIN(HL_MS) AS HL_MS,reshack FROM NatHotLap WHERE track = '$p_id' GROUP BY 'disp','online','Username','track'  ORDER BY 'HL_MS' ASC  ";[/code]

[craygo]

Date are stored in mysql as YYYY-MM-DD you cannot use YYYY/MM/DD use is exactly as I gave it. You do not need the time either. It will just go right by it.

Ray