[SOLVED] mysql query select last week

[corillo181]

hi!

i got a mysql table with different dates.

i would like to make a query that select everything between today and last week.

i got the logic which is.

 

$today = strtotime('now');
$lastweek = strt0time('-1 week');
$query ="select from product where unixtime_stamp(date)>='$lastweek' and unixtime_stamp(date)<$today";

[corillo181]

any guess anyone?

[MadTechie]

try this

$query ="select from product where unixtime_stamp(now())>='$lastweek' and unixtime_stamp(now())<$today";

[corillo181]

i haven't tried that code but where dose it compare to the date field where i want to get the result from?

[MadTechie]

i used NOW(), i guess you could add the () after the date on your version