Knowledgebase
View categorized listing of all common frequently asked questions.
Video Tutorials (jReviews 2.0)
Learn how to create a Movie & TV Show review website.
Learn how to start customizing the jReviews theme.
Forum
Community forum
Submit a Ticket
Use your client area email to access the ticket system.
Downloads
Guides, modules and more...
CSV Import for Joomla and jReviews
 
Welcome, Guest. Please login or register.
Did you miss your activation email?
November 20, 2008, 10:50:11 AM
21273 Posts in 4853 Topics by 2793 Members
Latest Member: panos
News: Use your client area email when you sign up to the forum so we can identify you as a trial or licensed user. Otherwise we may not answer your questions.
 
jReviews Support Forum  |  jReviews 1.x - jReviews Modules and Hook Components  |  Modules & bots  |  Date listing in modules « previous next »
Pages: [1]
Author Topic: Date listing in modules  (Read 1762 times)
andragor
Jr. Member
**
Offline Offline

Posts: 28


WWW
« on: June 27, 2008, 10:29:18 AM »

Hi, Alejandro!

Is it possible to show in a module a list of items by date custom field?

For example, show all items in module for which jr_date field is equal to 27.06.08.
Logged
Alejandro
Global Moderator
Administrator
Hero Member
*****
Offline Offline

Posts: 8444


« Reply #1 on: June 27, 2008, 11:15:54 AM »

There's a WHERE parameter in the module for the custom mode and you could enter something like:

jr_date = "27-06-2008"

You need to check exactly how the field is store in the database in jos_jreviews_content so you can enter the correct value to look for.
Logged

Please take the time to vote and to write a review: http://extensions.joomla.org
Reviews Ahoy! - Submit your jReviews site here.
andragor
Jr. Member
**
Offline Offline

Posts: 28


WWW
« Reply #2 on: June 28, 2008, 04:54:42 AM »

Thankee, Alejandro, that did it!

And the last paragraph of your comment was the most important as the date value is stored with the time: "2008-06-27 00:00:00"
Logged
Pages: [1]
« previous next »
    Jump to: