selecting all rows 7 days from now based on unix timestamp and current date

[EmmanuelM]

I have a table with the following fields:\[code\]id - intname - intthe_date - int\[/code\]\[code\]the_date\[/code\] is a unix timestamp for when the row was addedNow I am trying to write a query that will select all rows on the day that is 7 days from now. I'm not talking about select the rows >= 7 days from \[code\]time()\[/code\], I need to grab the current day using \[code\]time()\[/code\], and then run a SELECT that grabs all the rows that were inserted on the day that is 7 days from the \[code\]time()\[/code\].I know how to do it so its within 7 days from the \[code\]time()\[/code\] with a simple >= SELECT, but I don't know how to do it so it selects all rows whose unix timestamp is on that particular day (7 days from now).Any help would be greatly appreciated.