If you develop WordPress themes, you have probably come across the need to display posts within a certain range of dates. Unfortunately, this isn’t something you can easily do within the query_posts(); function. However, you can still do this by creating and running a filter. Add the following code BEFORE the query_posts(); function:
function filter_where($where = '') { $where .= " AND post_date > '" . date('Y-m-d', mktime(0, 0, 0, date("m") , date("d") - 7, date("Y"))) . " 00:00:00' AND post_date < '" . date('Y-m-d', mktime(0, 0, 0, date("m") , date("d"), date("Y"))) . " 23:59:59'"; return $where; } add_filter('posts_where', 'filter_where');
This filter will display all posts from 7 days before the current date, starting at midnight, until the current day at 11:59:59pm. This can be especially useful if you want to a box on your sidebar that shows only your posts from the past week.
After you run your query, be sure to include:
remove_filter('posts_where', 'filter_where');
If you don’t remove the filter, all other queries on the page will have the filter applied to it as well.
Great idea, but how could I update the filter to include posts from that date range conditional on a meta_key=status meta_value !=4
Grateful for any advice!
-Roger
[...] 123456789101112131415560sec Cheap 1991 Mercedes, 560sec Headlight 1990 Mercedes Stabilizer Bar Auto Parts560sec Cheap 1991 Mercedes, 560sec Headlight 1990 Mercedes Stabilizer Bar Auto Parts560sec wholesale expertise mercedes benz 560sec 2nd hand 2009 mercedes 560sec zone new zealand cars 560sec baseboard bmw sale 560sec cl mercedes benz 300sl 560sec headlight betten imports az 560sec 198 mercedes benz wood trim new mercedes benz 560sec rear 560sec used parts 1991 mercedes muffler mercedes benz 560sec parts 560sec factory sel rear leveling auto 1986 used mercedes benz 560sec 560sec times 1989 mercedes benz 560sec hamann 560sec auction auto mercedes discount 560sec parts mercedes benz 300cd 560sec info mb coupes 560sec specifications catalytic converter buy 300e 560sec 560sec wicked 560sec discount 1990 mercedes power lock problem 560sec oem discount 560sec parts recycling new mercedes benz discount ignition wire mercedes benz 560sec 560sec rock 560sec headlight 1990 1987 mercedes benz 380sl mercedes benz 560sec part oxygen sensor fmvss 108 560sec 1995 560sec cooling system brand parts mercedes 560sec free sel 1986 mercedes 560sec radiator aftermarket report 560sec classifieds 560sec hid fog light auto parts 560sec parts custom 560sec promotion 560sl 500sel 560sec bulbapedia 560sec antiques used 1991 560sec parts fog light mercedes benz e55 amg mercedes benz 560sec radiator oxygen sensor brake pads 560sec omd 560sec parts 1986 mercedes brake rotors windshield washer fluid sale 560sec 1989 mercedes benz 560sec radiator coupons 560sec discount fuel pump mercedes w107 fcp groton 560sec cheap 1991 mercedes 560sec aftermarket auto parts 198 mercedes benz 560sec oem high 560sec discount replacement s55 clk55 amg 560sec guy 560sec part discount 1988 mercedes 560sec auction auto sport coupe bumper used mercedes benz 560sec 560sec clearance 1985 mercedes benz 560sec catalytic converter 560sec msrp used mercedes benz 560sec pt in stock buy 560sec 1980 mercedes 560sec 0 60 part car used mercedes benz series 560sec used parts mercedes benz 560sec cls63 cl65 amg 560sec ptt health 560sec apartments 560sec pt car mercedes 560sec for sale southern california sale 560sec 1986 mercedes benz promo w126 560sec 560sec antique 1987 mercedes benz 560sec aftermarket promo 1989 mercedes benz 560sec replacement differences 560sec game sel 560sec oem 1989 used mercedes benz 560sec wholesale assembly promotion diesel 560sec 560sec central heating aftermarket clk55 amg 560sec zone buy 560sec skin 560sec parts accessories 1991 mercedes benz 1988 mercedes benz 560sec coupe sl 420sel free shipping 560sec 560sec truck light 560sec pt car leather seats 560sec hid h7 kit 560sec hid promo porsche 560sec radiator fog lamps mercedes 560sec truck 1986 mercedes benz 560sec parts oxygen sensor 560sec xenon hid 560sec headlight promotion mercedes 560sec full world 560sec free catalytic converter 560sec parts junk yard 560sec cooling system call 560sec coupon 1991 mercedes benz 500 560sec parts fit catalytic converter oxygen sensor 560sec discount 560sl 500sel benz 560sec socket car parts 560sec inexpensive car 560sec used display mercedes benz club of america 560sec used parts 1990 mercedes 560sec parts kelly blue book 1969 Mercury Cougar | Ln7 Clearance Business | 1975 Plymouth Volare | Replacement Saturn Sc2 | S65 Amg Floor | [...]
[...] 1234567891011121314151617181920212223242526272829303132325i Projector Headlights Bmw E46, 1994 Bmw 325i Rims Brake Pads325i Projector Headlights Bmw E46, 1994 Bmw 325i Rims Brake Pads325is sale mercedes forum xenon headlights 325is sale form used bmw 3 series 325i equipped automatic transmission leather interior bmw 325i headlights model convertible 1995 bmw 325i bmw 325i specs tail light bulb fiabilite 325i e36 stock bmw 325i parts replacement 1996 bmw 325is 324td coupon 325ix 1998 bmw 325i aftermarket parts 1980 528i radiator 325is 1988 bmw 528e 325ix available replacement fuel pump 325i ginuwine radiator discount 2005 bmw 325i 2001 bmw 325ix sedans second hand 325i 325ix auto manual bmw 2006 bmw 325i complaints fuel injection system bmw 325ix taillight fog light cold air intake for 1993 bmw 325i 1988 used parts 1993 325i bmw 325e 325is wholesale 328i bmw 330xi bmw 325i headlight lens replacement 325ix radiator heater core replacement 325ix e30 verbrauch 325is radiator nissens bmw 318is autohaus az 325ix halogen fog light bulb 325i rebuilt transmissions 325is tail light assembly headlight switch 1994 bmw 325i rims brake pads radiator offers 1993 bmw 325i transmission oil cooler 325i standard equipment 1990 bmw 325i overheating head gasket 325i azores buy 325is 1987 bmw 325 325is bumper cover aftermarket sale 325i parkers price bmw 325i buy 325is market 325i 320i petrol bmw car 325es aftermarket 2005 bmw 325i auto parts 2001 bmw 325i window regulator 325is wholesale parts bmw 740i replacement headlight assembly 1994 bmw 325i 328ci pt discount bmw 325i 325ix pet divider bmw 325i bulb headlight bmw 330ci 325ix stop bmw 325e 325i discount dealer e30 bmw 320i 325ix rebuilt transmission 1993 325is performance bmw series 1994 bmw 325i accessories cold air intake e30 radiator bmw 325i 325i aftermarket fog tail lights bmw 3 series 325is tube quality 325ix fix 2004 bmw 325i for sale mpg 325ix coolant auto parts radiator drain plug 2006 bmw 325i navigation system 325ix condos 325is discount 1995 bmw 325i discount replacement 325i bmw brake pads 2001 325i fuel pump discount parts 325i accessories bmw fuel pump part bmw 325ix discount cold air intake bmw 325i fan resistor 325i promotion remanufactured 325ix headlight body e30 bmw 325es radiator plastic tanks 1995 325is bmw 325ci e30 part manual transmission bmw 325i e46 325i video 2001 bmw 325i light bulb 325ix parts 323i bmw 330xi 325i promo bmw series 1991 sale 1994 bmw 325i honda bmw 325i sport 2007 bmw 325ix 325is new manual 2001 325i owner manual 325is dealers 1987 325i convertible hardtop bmw e30 325i free shipping bmw series 1989 bmw 325i head oil pan 2001 325i fan clutch removal used 325i sedan bmw 528i 325i sport acura tl 2006 bmw 325i vs 330i wheels part 2006 325i 323i bmw 325xi 1980 528i bulb 325is bmw 740i 2001 bmw 325i bluetooth retrofit 325i second hand bmw 3 series 325i free shipping catalytic converter z4 coupe precios bmw 325i 325i e38 bmw 740i 325is replacement autozone refurbished online bmw 325i 1993 bmw 325i body parts 325ix body kit e46 bmw 325ci 1993 bmw 325i cd changer Cobalt Body Kits | 1998 Gmc Sonoma | 200sx Fog Tail | Ml430 Msrp Autos | 1998 Sl320 Mercedes | [...]
[...] 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849Replacement Compaq Armada E500 Cell, Star Trek Armada Mods Star WarsReplacement Compaq Armada E500 Cell, Star Trek Armada Mods Star Warsmurano 2009 nissan armada watch transformers armada online free armada schlacht england 2006 nissan armada interior pictures armada rubber 2009 nissan 1991 nissan pathfinder parts 2004 armada buy star trek armada online star trek armada cheats gamefaqs armada clearance packages armada discount china nissan armada sale virginia armada ar6 wood laminate diagram compaq armada m700 armada wiki armada ar6 skis swing weight groove armada soundboy rock recensione armada dvd 2006 nissan armada chicago 06 nissan armada accessories 2007 nissan armada exhaust mandrel bent tubing armada movie ships armada headlight high quality direct fit oe repair nissan pathfinder armada wiki nissan armada bumper replacement grille guard nissan armada 4wd light center console parts 2008 nissan armada sunroof wind deflector cargo mats sale search 2004 nissan armada star trek armada mods star wars pathfinder armada forum 2007 infiniti qx56 interior nissan armada 2005 nissan armada reviews second row armada market mi real estate cost used nissan armada nissan armada discount towing capacity lbs hands time armada lyrics armada qx56 conversion nissan titan forum video game star trek armada ii 2007 armada headlight bulb 2002 nissan xterra oem 2008 nissan armada wheel covers armada portugal portuguesa 2006 nissan armada dvd player 2004 nissan pathfinder armada chevrolet tahoe armada bulb 2008 nissan titan 2006 nissan armada options colors armada headlight weathertech fog lamps infiniti qx56 nissan armada large suvs headlight high quality armada 2008 nissan titan wildcat ratatat spanish armada desert eagle aftermarket 2009 nissan armada pathfinder fog lights nissan armada cold air intake free shipping star trek armada grafik probleme infiniti socket armada forum used armada memphis nissan sentra nissan armada bulb grille used 2005 nissan armada ma nissan armada for sale in wyoming spanish armada ships pictures spanish armada leaders armada full family aftermarket 2008 armada altima coupe nissan 370z queen elizabeth spanish armada duke of parma gmc yukon xl 2500 mpg nissan armada 2006 armada tires how to remove nissan armada car armada promo nissan xterra roof rack taillight 2008 nissan armada sae nissan armada headlight bulbs used nissan armada sale los angeles armada parts store nissan xterra armada truck nissan armada blb sylvania nissan armada park sensor towing surrounding the defeat spanish armada duke of parma armada ac free shipping sell 2005 nissan armada classified listings armada fog lights driving lamps armada discount xterra roof rack 2009 nissan pathfinder amazon armada these gateway armada for sale tractor armada mi p3500 upgrade compaq armada armada order nissan parts license plate frames nissan armada dvd download pictures 2005 nissan armada compaq armada 4120 keyboard armada laptop hard drives nissan armada fog light brakes armada half black 2007 nissan armada accessories splash guards 2007 nissan armada bumper armada forum nissan engine b b b armada b exhaust system nissan titan list nissan armada accessories titan oem armada armada engine parts last minute groove armada compaq armada 7800 sterowniki nissan armada for sale mo nissan armada us armada door Cirrus Q Parts | Grandville Headlight Xoxo | Ford Caravelle Volkswagen | Starfire Performance Engine | F59 Electric Ford | [...]