[RESOLVED] Dates() ad infinitum

[TobyRT]

Hi,

I've got a page where I basically want to list the events for the forthcoming month on my front page.

I've found a way of doing this in my SELECT query using DATE_ADD, but I'm already using UNIX_TIMESTAMP for that field in the query and I'm not sure how to nest them.

I'm sure there's a way using php, but I've just looked at the manual and can't see any syntax using the date() function to list events for the next 30 days or so.

Can anyone give me any advice/point me in the right direction?

Here's the SQL:

$result = $connector->query('SELECT id, eventname, eventdesc, UNIX_TIMESTAMP(eventdate) AS eventdate, eventloc FROM events ORDER BY eventdate ASC') or die ("Error in Query: $query.".mysql_error());

[devinemke]

SELECT * FROM events WHERE eventdate <= DATE_ADD(CURDATE(), INTERVAL 30 DAY)

[TobyRT]

Ah, of course - the Date_add is a conditional isn't it? It doesn't have to be in the FROM section of the query - it comes afterwards.

DOH!

[devinemke]

actually, this would be more what you had orginally asked for:

SELECT * FROM events WHERE eventdate BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 30 DAY)

[TobyRT]

OK, now I'm confused - what does the first one do then?