TO_DAYS recordset problem

[vinny199]

Hi,

I am having the following problem.
I used to be able to set a date filter in my recordsets to display events only from a certian date, no problem.
But i was dealing with a database that had a "date filed": eve_date that would clearly register the date of the event in a "computarised manner" such as:

20050302 for 2005 03 02

so, the following would work well:

WHERE (TO_DAYS[(eve_date)] - TO_DAYS(NOW()) < 0)
ORDER BY eve_date DESC

I'm dealing with a database here where the date is split in 3 disctinct fields:

$year
$month
$day

I cant really change the database structure, it would have too big implications, but i need to set a similar date filter on some pages.

I am just completely stuck on how this could be done as to compiling these 3 fields into one "eveor even better, use the

WHERE (TO_DAYS[(year month day)] - TO_DAYS(NOW()) < 0)
ORDER BY year month day DESC

kind of thing.

Can you help?

Many thanks,

Vinny

[Yamakazi]

Do it with a sub-select and just concat the fields in one field. BTW can you provide the DB you are talking about there. It looks like MySQL?

Edit: Isn't that a very weird way to only select the records that have a date in the future?

[vinny199]

Yes, it is MySql database,

Many thanks for your response, but could you please give me a practicle example of what you describe?I'm still a begginer with php

I tried this, but no luck, am i on the right tracks though?

WHERE (TO_DAYS((year) AND (month) AND (day)) - TO_DAYS(NOW()) < 0)

Cheers,

Vinny

[vinny199]

Could someone please help further with this?

I'm still very stuck, cant figure it out,

many thanks,

vinny