Results 1 to 3 of 3

Thread: Ending Today Widget

  1. November 29th, 2012 #1
    frostiecuk
    frostiecuk is offline
    Thread Starter
    Member frostiecuk's Avatar
    Join Date
    Nov 2011
    Location
    United Kingdom
    Posts
    84
    Thanks
    11
    Thanked 3 Times in 3 Posts

    Ending Today Widget

    Hi all

    Just wondered if anyone has managed to create an "ending soon" widget or PHP code that can be executed in the sidebar on the homepage? This type of thing prompts a user to visit and make use of the coupon before it ends and could generated a few extra $'s.

    Normally I'd be able to knock something together but with the backend of Clipper it's not that straight forward. The code I have so far is
    SELECT * FROM wp_posts WHERE post_type = "coupon" LIMIT 10
    However I now need to add an additional match that says something along the lines of "WHERE DATE = TODAY". Has anyone got any suggestions?
    Reply With Quote Reply With Quote
  2. November 29th, 2012 #2
    frostiecuk
    frostiecuk is offline
    Thread Starter
    Member frostiecuk's Avatar
    Join Date
    Nov 2011
    Location
    United Kingdom
    Posts
    84
    Thanks
    11
    Thanked 3 Times in 3 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!
    Reply With Quote Reply With Quote
  3. December 1st, 2012 #3
    couponminister
    couponminister is offline
    couponminister's Avatar
    Join Date
    Aug 2012
    Location
    India
    Posts
    172
    Thanks
    16
    Thanked 6 Times in 6 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!
    CouponMinister.in (now Klypy India) is a popular discount coupon website for brands in India.
    Reply With Quote Reply With Quote
« Email Subscription and Breadcrumb - Clipper | how to post coupons as just one store when it comes out in search results »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Popular Ads Today Widget Timing
    By essej88 in forum Report ClassiPress Bugs
    Replies: 2
    Last Post: July 20th, 2010, 10:21 AM
  2. Popular Ads Today Widget
    By essej88 in forum Help Using ClassiPress
    Replies: 0
    Last Post: June 14th, 2010, 12:56 PM
  3. Top Ads Today Widget
    By essej88 in forum Help Using ClassiPress
    Replies: 1
    Last Post: June 11th, 2010, 02:38 AM
  4. Issue with Top Ads Today Widget
    By webdevil in forum Help Using ClassiPress
    Replies: 2
    Last Post: June 3rd, 2010, 01:02 AM
  5. Top Ads Today Widget
    By webdevil in forum Help Using ClassiPress
    Replies: 2
    Last Post: May 30th, 2010, 09:21 PM