Support Center

Knowledgebase
View categorized listing of all common frequently asked questions.
Video Tutorials
Create a Movie & TV Show review website.
Customize the jReviews themes.
Review user profiles with the Everywhere addon.
Forum
Community forum
Submit a Ticket
Use your client area email to access the ticket system.
Downloads
Guides, modules and more...
 
Welcome, Guest. Please login or register.
Did you miss your activation email?
January 08, 2009, 09:43:46 PM
22868 Posts in 5233 Topics by 2978 Members
Latest Member: mini_me
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 1970 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: 9030


« 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

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: