• bots
  • code
  • ecommerce
  • misc
  • search
  • software
  • tips
  • tools
  • wordpress

Big Webmaster

  • a do follow blog

MySQL Query on timestamp using PHP

on March 11, 2010 - 0 Comments
code

standard timestamp field in MySQL

In this example I had to create a query only to display orders for the last 90 days. The orders table is using a standard MySQL timestamp field to store the date of the order. I made timestamp indexed since we will be doing this query against this field. I figured the easiest way was [...]

Read more ยป

Share your thoughts!

  • Recent Posts

    • Fancy way to describe a screw up
    • Is your Gmail Account Active. Yes/No
    • Page Not Found when WordPress Category Tag matches Page name
    • Adsense Ad Bad Practice
    • GoDaddy Certificate Seal Spam
  • Recent Comments

    • Asho on Short Meta Descriptions Can Kill Your Website
    • Tom on Musical Notes
    • Samantha on WordPress Automatic Update with 1and1
    • bigboy on Musical Notes
    • Missy on Solved: URL file-access is disabled in the server configuration
  • Archives

    • September 2011
    • July 2011
    • March 2011
    • February 2011
    • December 2010
    • November 2010
    • September 2010
    • August 2010
    • July 2010
    • April 2010
    • March 2010
    • January 2010
    • December 2009
    • November 2009
    • September 2009
    • August 2009
    • May 2009
    • April 2009
    • February 2009
    • December 2008
    • November 2008
    • September 2008
    • July 2008
    • June 2008
    • April 2008
    • February 2008
  • Follow Me On Twitter
  • Links

    • Best of the web
    • Iraqi Dinar
    • Nursing Home Report
    • Pair Web Hosting
    • Submit Your Blog
    • XML Sitemap

Copyright © 2012 Big Webmaster