SELECT FROM ..WHERE date < 30 days ago?

[Dolemite50]

Hi,

I have a mysql table with a date time field. The date is stored like this: 2004-11-10 19:04:23.

I am trying to select entries from a range of "within the last 30 days". After searching the board it looks like strtotime is the way yo go but I can quite get the syntax right.

Here is my latest attempt:

$thirty_days_ago = date(strtotime('thirty days ago'))	
//exit ($thirty_days_ago);//If i exit here it says -1 ??
$sql5 = "SELECT songid, stitle FROM songs WHERE sdate >= '$thirty_days_ago'"; 

But no luck. I noted where if I exit at that point it says -1. ??

Thx for any help.

[Dolemite50]

Oopps,
I noticed that I spelled "thirty" instead of using 30. While I am here, this was the output for $thirty_days_ago:

1100414068

Does that look right? How do I read that?

[Dolemite50]

I dont think its right. It is not giving me only entries in the last 30 days if I try the following code:

$thirty_days_ago = date(strtotime('30 days ago')); 
$sql5 = "SELECT songid, stitle FROM songs WHERE sdate > '$thirty_days_ago'"; 

It is pulling every record from the DB instead of just the ones within the last 30 days, do I have to format the date different somehow? What am I doing wrong here?

[xblue]

strtotime() returns a unix timestime. feeding that into date() as first argument which is supposed to be the format is not likely to get you the desired result, I think.

if you want to keep with php date functions, I'd recommend at least to echo your query to make sure $thirty_days_ago looks the way you want.

else give the mysql date functions a try:

SELECT songid, stitle FROM songs WHERE sdate > NOW() - INTERVAL 30 DAY