Hi all,

I'm currently using Dreamweaver MX, PHP and MySQL to create a relatively simple website where I store events that are happening at skateparks throughout the UK.

My problem is that I don't have a clue about how to filter my records to show only those that are after todays date.

I have:

SELECT *
FROM news
WHERE fromDate >= 'colname' AND news.type = 'e'
ORDER BY fromDate DESC

'colname' = $_SERVER['TTOD(DATETIME())']

The event types ('e') are selected successfully, but, unfortunately, the current date thing doesn't seem to do anything.

How can I filter my recordset with current system date?

Any help greatly appreciated.

Use something like

SELECT *
FROM news
WHERE fromDate >= now() AND news.type = 'e'
ORDER BY fromDate DESC

omiossec (?) -- A big thank you -- that worked perfectly.

I'd read elsewhere on the web that now() didn't work -- I obviously went to the wrong site!!

Wes