Hi, I'm creating articles in Joomla 2.5.4 and the setting the "Finished Publishing" date. Once that date has past, In the admin section the article has a red x and says "publishing expired".
I'm doing some manual pulls from the sql db, with the conditional "state =1" to show all published articles and to Hide the expired articles. i thought the state=1 is published, state =0 is the unpublished, state = -2 is trashed. However when the article is expired (past the finished publishing date), the state still shows as 1 in the database, so my custom module is still showing the expired article, but the link to the actual article is not valid. Any ideas how I can identify from the database when an article is expired? I'm wondering why the state still shows as "1" for expired articles. thanks in advance. Todd
_______________________________________________ New York PHP SIG: Joomla! Mailing List http://lists.nyphp.org/mailman/listinfo/joomla NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
