I need to select data from mysql for last 7 days. I have field named 'date' and which have values in mm.dd.yy format. 
So i tried to find special mysql request to do that, but its not work with my field, i gues that beacause date in wrong format.
How i can do that from php (use some variable to get mysql entries), or with custom select query ?