Hi, I've got a database of articles. It includes a 'publish date' field and a 'stick to publish date' box. Now, the box is 'on' on default. If a user adds an article, he can put it in to show up in the future, say 2 weeks from now.

I know how to compare the date with todays date, but where exactly and how do I put it in the code. I guess it needs to be done at query in db.cgi, but I'm not sure... Because, if the field is set (when doing a search) to 'on' I don't want the record to be included in search results. That would happen if I'd put it in sub html_record in html.pl

To compare the dates I found this:



Has anybody seen something like this already explained in the forum?

Any help is appreciated.

Lex

Here's my solution if anybody is ever interested:

in db.cgi where you get the 'next line if' (to not include the record in the 'found records') I inserted this (underneath first next LINE) (so the first two lines underneath are already in your db.cgi):




A bit above this, before it says 'foreach field' I inserted:


(so it wouldn't have to call the function for each record)

For this to work you need te set the PublishDate_field and SticktoDate_field in your .cfg file, like this:

$PublishDate_field = 13; # (if that's your field number)

"if ($in{'view_records'})" is there so it's only doing this when viewing records, not when modifying or anything else.

Maybe somebody likes it...

Have fun,
Lex

That's really cool... I often get lost when attempting to hack the db.cgi.