Please help ...

[romic]

Please answer me the following question: I need to make a script for "Hot Deals". In the database I have the fields for "Hot Deal Start Date" and "Hot Deal End Date" How should I compare 2 dates in PHP(the "Hot Deal End Date" and today's date), so that I would be able to select from the database only the results I need, not al the results.

Thanks.

[yelvington]

This really is a database question, not a PHP question.

If you have dates for beginning and end of activity, all the active records would be returned by a SQL query like this:

SELECT something FROM sometable WHERE startdate <= NOW() AND enddate >= NOW()

If you are using MySQL, read the section of the MySQL manual that covers date and time functions. It is informative and full of examples.

[romic]

Thanks for the information.
I'll see what I can find on mysql's site.