Lawrence,

Thank you for your answer.

I will have a look at the links you gave me.

Kind regards,

Martin

Dear mr. Moore,

Perhaps I have a not so smart question but I wonder if this method

can be used on mysql databases as well for as far as I know one...

It works!!! Thanks a lot.

Kind regards,

Martin Smits

Hi,

this is what i've tried:

Select * from `tbl_nieuws` where getdate() between `start_datum` and `eind_datum`

This provides the following error.

#1064 - You have an error in your SQL syntax; check the manual...

Here you are

id bigint(11) Nee auto_increment

titel text utf8_unicode_ci...