ewadrel Posted October 23, 2006 Posted October 23, 2006 hello all, I noticed that the newsdesk_date_available option is not used in the SQL statment, used to display the list of latest news. How come when it is a necessary option ? I added "and newsdesk_date_available <= now()" on the page /catalog/includes/modules/newsdesk.php but it doesn't show anymore the news with a NULL 'newsdesk_date_available' in the table newsdesk. Only News with a past date are displayed (ie today minus 1,2,3 x days). Do you know why ? WHERE p.newsdesk_id=p2c.newsdesk_id and p2c.categories_id=pc.categories_id and pd.newsdesk_id = p.newsdesk_id and pd.language_id = "' . $languages_id . '" and newsdesk_status = 1 and p.newsdesk_sticky = 0 and newsdesk_date_available <= now() ORDER BY newsdesk_date_added DESC LIMIT ' . MAX_DISPLAY_NEWSDESK_NEWS What is the correct SQL statement ? Thx, Best to all Ewad Quote
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.