[SOLVED] SQL statement

[gple]

How do i use today's date to find all records in an SQL statement that are all within one year of todays date.

 

$date="2007-10-31";

$tday=date("Y-m-d");

 

how do i run a query to check if $date is less than one year of $tday.

[awpti]

<?php
$today = date('Y-m-d');
$last_year = date('Y-m-d', strtotime('last year'));

// The above is very rough, you shouldn't actually use strtotime 

$res = mysql_query("SELECT * FROM some_table WHERE my_date_field BETWEEN '{$today}' AND '{$last_year}'");