mysql update

1. Tarkim turiu irasa kuris buvo patalpintas 2013.02.02

2. Ir turiu irasa patalpinta 2013.02.01 ir ji atjaujinu 2013.02.02 ir noriu, kad ji rodytu aukciau uz pirmaji varianta (ta prasme visi atnaujinti irasai pagal data aina i virsu)

Kaip tai padaryt?

Kodas dabartinis pas mane toks:

$sql = "SELECT a.*, ct.cityname, UNIX_TIMESTAMP(a.createdon) AS timestamp, feat.adid AS isfeat,

COUNT(*) AS piccount, p.picfile AS picfile, scat.subcatname, scat.catid, cat.catname

FROM $t_ads a

INNER JOIN $t_featured feat ON a.adid = feat.adid AND feat.adtype = 'A' AND feat.featuredtill >= NOW()

INNER JOIN $t_cities ct ON a.cityid = ct.cityid

INNER JOIN $t_subcats scat ON a.subcatid = scat.subcatid

INNER JOIN $t_cats cat ON scat.catid = cat.catid

LEFT OUTER JOIN $t_adpics p ON a.adid = p.adid AND p.isevent = '0'

WHERE $visibility_condn

$loc_condn

GROUP BY a.adid

ORDER BY a.createdon DESC

LIMIT $latest_featured_ads_count";

$res_latest = mysql_query($sql) or die($sql.mysql_error());

Datą atnaujink.

P.S. Koks klausimas, toks ir atsakymas

SELECT * 
FROM table WHERE DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= data 
ORDER BY data DESC

išdėlios 7 dienų paskutinius įrašus rikiuojant pagal datą