View Full Version : How do I display data from a certain date?

06-15-2011, 02:49 PM
Anyone know how I can display data from a specific date.

for example posts from today

06-15-2011, 05:25 PM
It would be helpful to know what fields are available, of course we would need the record to hold a timestamp of date. Is this something for Joomla, Wordpress or alikes?

06-16-2011, 07:57 AM
I think you mean archiving. While publishing post just save the date of publish too. Retrieve those post with a particular date by using the condition where date="value"

08-23-2011, 12:29 PM
These two steps, but I like it this way:

First create a file with a date / time. In this case, the file is 01/10/2008 at midnight

touch-t 0810010000 / tmp / t

We can now find all files that are newer or more than the above file (is on file modification date. It can also be used to access cnewer anewer-and-file status changed).

find /-new / tmp / t
find / no-newer / tmp / t

You may also search the files between dates determined by creating two files with the touch

touch-t 0810010000 / tmp/t1
touch-t 0810011000 / tmp/t2

This files are located between the two dates and times

find /-new / new tmp/t2 tmp/t1-y-no-más /

08-23-2011, 02:05 PM
mrkaassis, your solution has nothing to do with mysql though.

08-23-2011, 02:07 PM
Fatdank, are your values DATE or DATETIME? if DATE use CURDATE() to find values matching today's date. If DATETIME use BETWEEN.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum