Php+mysql query specified date record of this month's data hits

$time = time ();
$days = 86400*30;
$sql = "SELECT * from Test where $time-updated< $days ORDER BY click_num desc limit 10";
$db = ' Daydb ';
$query = Mysql_db_query ($db, $sql, mysql_connect (' localhost ', ' root ', ' root '));
if ($query)
{
while ($rs = Mysql_fetch_array ($query))
{
echo $rs [' id '], $rs [' title '];
}
}
Else
{
Echo ' query failed ';
}

Example two query one year click the code
$days = 86400*365; Here to say 86400 represents a day.
$sql = "SELECT * from Test where $time-updated< $days ORDER BY click_num desc limit 10";
/*
Time () This function is to get the current server time truncation
Mysql_db_query SQL query execution direct with database tutorial
Mysql_connect Database Connection
Mysql_fetch_array saves the current record in an array
This site original tutorial reproduced annotated source http://www.111cn.net/phper/php.html
*/